Saturday 26 December 2015

Networkdays with saturday | Qlik Community

Networkdays with saturday | Qlik Community: "floor(((Date2 - Date1)+1)/7)*6 + mod((Date2 - Date1)+1,7)
+ if(Weekday(Date1) + mod((Date2 - Date1)+1,7) < 7, 0, -1) as Workingdays_6"



'via Blog this'

YA(H)Q Blog: Qlikview Working Day Functions 1

YA(H)Q Blog: Qlikview Working Day Functions 1:



'via Blog this'

Tuesday 22 December 2015

DB Browser for SQLite

DB Browser for SQLite:



'via Blog this'

QlikView macro's are bad! - The Qlik Fix! The Qlik Fix!

QlikView macro's are bad! - The Qlik Fix! The Qlik Fix!:



'via Blog this'

Execute a Macro inside load script | Qlik Community

Execute a Macro inside load script | Qlik Community:



'via Blog this'

QlikTip #17: Simulating the $(include) command in QlikView macros

QlikTip #17: Simulating the $(include) command in QlikView macros:



'via Blog this'

QlikTip #32: Exporting multiple QV objects to a single Excel document

QlikTip #32: Exporting multiple QV objects to a single Excel document:



'via Blog this'

QlikView Macros – Useful collection | Lucian Cotea

QlikView Macros – Useful collection | Lucian Cotea:



'via Blog this'

Fast Change using a button | Qlik Community

Fast Change using a button | Qlik Community: "0=Unknown
1=List Box
2=Multi Box
3=Statistics Box
4=Table Box
5=Button
6=Text Object
7=Current Selections Box
8=Input Box
9=Line/Arrow Object
10=Pivot Table
11=Straight Table
12=Bar Chart
13=Pie Chart
14=Scatter Chart
15=Line Chart
16=Combo Chart
17=Custom Object
18=Bookmark Object
19=Slider/Calendar Object
20=Grid Chart
21=Radar Chart
22=Gauge Chart"



'via Blog this'

Saturday 12 December 2015

Calendar with time (timestamp) | Qlik Community

Calendar with time (timestamp) | Qlik Community: "
Calendar:LOAD AddedTimeStamp AS MyTimeStamp,   
     Year(AddedTimeStamp) AS MyYear,// And so  
 
This will create a Calendar with all possible timestamps between the first second (00:00:00) of the first date to the last second (23:59:59) of the la"



'via Blog this'

Thursday 3 December 2015

Tuesday 17 November 2015

Number formatting - millions to billions | Qlik Community

Number formatting - millions to billions | Qlik Community: "=If(sum(Amount)/1000000000 > 1,Num(sum(Amount)/1000000000,'$#,###B'), Num(sum(Amount)/1000000,'$#,###M'))
"



'via Blog this'

Monday 9 November 2015

Friday 30 October 2015

Polymorphic Associations in Rails 4 | Alex Stockwell

Polymorphic Associations in Rails 4 | Alex Stockwell:



'via Blog this'

Why 5 x 3 = 5 + 5 + 5 Was Marked Wrong — Math Memoirs — Medium

Why 5 x 3 = 5 + 5 + 5 Was Marked Wrong — Math Memoirs — Medium:



'via Blog this'

Paul Noble vs. Michel Thomas | Blog

Paul Noble vs. Michel Thomas | Blog:



'via Blog this'

6 Breathing Exercises to Relax in 10 Minutes or Less | TIME.com

6 Breathing Exercises to Relax in 10 Minutes or Less | TIME.com:



'via Blog this'

Online Training, IT Technology Business Certification Courses - acadgild.com

Online Training, IT Technology Business Certification Courses - acadgild.com:



'via Blog this'

Learn Web Design | Bloc Course Syllabus

Learn Web Design | Bloc Course Syllabus: "prior design or coding e"



'via Blog this'

Bloc | The World's Largest Online iOS Bootcamp

Bloc | The World's Largest Online iOS Bootcamp:



'via Blog this'

Learn Android Development | Bloc Course Syllabus

Learn Android Development | Bloc Course Syllabus:



'via Blog this'

Learn Frontend Web Development | Bloc Course Syllabus

Learn Frontend Web Development | Bloc Course Syllabus:



'via Blog this'

This Artist Turns His 20+ Year Old Childhood Doodles Into Stunning Masterpieces | Diply

This Artist Turns His 20+ Year Old Childhood Doodles Into Stunning Masterpieces | Diply:



'via Blog this'

FullStack - Ofer Zelig's Blog

FullStack - Ofer Zelig's Blog:



'via Blog this'

22 Online Alternatives to Coding Bootcamps | SkilledUp

22 Online Alternatives to Coding Bootcamps | SkilledUp: " weeks"



'via Blog this'

Wednesday 7 October 2015

Evaluating "sets" in the context of a dimension | Qlik Community

Evaluating "sets" in the context of a dimension | Qlik Community:



'via Blog this'

QlikView Maven: Set analysis and chart dimension

QlikView Maven: Set analysis and chart dimension:



'via Blog this'

How does Set Analysis Work in QlikView | qlikcentral

How does Set Analysis Work in QlikView | qlikcentral:



'via Blog this'

Creating Rolling Year Over Year (YoY) Charts | Qlikcode

Creating Rolling Year Over Year (YoY) Charts | Qlikcode:



'via Blog this'

What are the Set Analysis,Set Analysis Syntax,Set Identifier,Set Operators, Set Modifiers in QlikView? — Mindmajix

What are the Set Analysis,Set Analysis Syntax,Set Identifier,Set Operators, Set Modifiers in QlikView? — Mindmajix:



'via Blog this'

Set Analysis in Qlikview And Its Components | Business Intelligence Tools

Set Analysis in Qlikview And Its Components | Business Intelligence Tools: "=sum({}Company_Name)>}Sale)"



'via Blog this'

Set Analysis in Qlikview And Its Components | Business Intelligence Tools

Set Analysis in Qlikview And Its Components | Business Intelligence Tools: "QVW"



'via Blog this'

The Magic of Set Analysis – Part III • Blog • AfterSync

The Magic of Set Analysis – Part III • Blog • AfterSync:



'via Blog this'

9 Secret Food Places In India That Are Open Way Past Midnight! | HolidayIQ Blog

9 Secret Food Places In India That Are Open Way Past Midnight! | HolidayIQ Blog:



'via Blog this'

Saturday 26 September 2015

A sneaky use of QlikView gauges - Doughnut gauges | Qlik Community

A sneaky use of QlikView gauges - Doughnut gauges | Qlik Community:



'via Blog this'

A sneaky use of QlikView gauges - Doughnut gauges | Qlik Community

A sneaky use of QlikView gauges - Doughnut gauges | Qlik Community:



'via Blog this'

David Doughnuts – A sneaky use of QlikView’s circular gauges

David Doughnuts – A sneaky use of QlikView’s circular gauges:



'via Blog this'

David Doughnuts – A sneaky use of QlikView’s circular gauges

David Doughnuts – A sneaky use of QlikView’s circular gauges:



'via Blog this'

Fortune Cookie BI: Twisting the knife in a useful pie chart

Fortune Cookie BI: Twisting the knife in a useful pie chart:



'via Blog this'

Pie chart having both Values and Percentages | The QlikView Design Blog

Pie chart having both Values and Percentages | The QlikView Design Blog:



'via Blog this'

How to merge (combine) date intervals in T-SQL

How to merge (combine) date intervals in T-SQL:



'via Blog this'

Set analysis Vs intervalMatch | Qlik Community

Set analysis Vs intervalMatch | Qlik Community:



'via Blog this'

Avoiding a gigantic intervalmatch | Qlik Community

Avoiding a gigantic intervalmatch | Qlik Community:



'via Blog this'

Friday 11 September 2015

Direct discovery not working in SR7? | Qlik Community

Direct discovery not working in SR7? | Qlik Community: "SET DirectStringQuoteChar = '"';
SET DirectIdentifierQuoteChar = '[]';"



'via Blog this'

Tuesday 25 August 2015

Wednesday 19 August 2015

Quick Development Tips: December 2012

Quick Development Tips: December 2012: "
"



'via Blog this'

Dynamic Ad hoc analysis in Qlikview | Smart ERP Solutions

Dynamic Ad hoc analysis in Qlikview | Smart ERP Solutions:



'via Blog this'

Dynamic Dimension on Charts using $Field | Qlik Community

Dynamic Dimension on Charts using $Field | Qlik Community:



'via Blog this'

Quick Development Tips: How to imitate two dimensional arrays in qlikview script

Quick Development Tips: How to imitate two dimensional arrays in qlikview script: "Sub GetItem(fromArray,intoVar,X,Y)
Let firstDim=SubField(fromArray,',',X);
Let $(intoVar)=PurgeChar(SubField(firstDim,';',Y),Chr(39));
Set firstDim=NULL();
End Sub

Sub FindItem(fromArray,intoVar,SearchFor)
let k=fromArray;
For each t in $(fromArray)
Let s=t;
if SubField(t,';',1)=SearchFor then
Let $(intoVar)=SubField(t,';',2);
Exit for;
end if
next
End Sub


Set MyArray="'A;Turkey','C;Usa','D;Canada'";
Set vGetTest=Null();
Set vFindTest=Null();

Call GetItem(MyArray,'vGetTest',1,2); //This line sets 'vGetTest' to 'Turkey'
Call FindItem(MyArray,'vFindTest','C'); //This line sets 'vFindTest' to 'Usa'"



'via Blog this'

Loop from an array | Qlik Community

Loop from an array | Qlik Community: "set vStuff="'aaa','bbb'";"



'via Blog this'

The Secret Life of SubField | Qlik Community

The Secret Life of SubField | Qlik Community:



'via Blog this'

Saturday 8 August 2015

Yesterday Karaoke The Beatles - You Sing the Hits - YouTube

Yesterday Karaoke The Beatles - You Sing the Hits - YouTube:



'via Blog this'

The Beatles-Yesterday Lyrics - YouTube

The Beatles-Yesterday Lyrics - YouTube:



'via Blog this'

One Direction - YouTube

One Direction - YouTube:



'via Blog this'

The Wiggles - YouTube

The Wiggles - YouTube:



'via Blog this'

Barney & Friends - YouTube

Barney & Friends - YouTube:



'via Blog this'

barney and friends full episodes - YouTube

barney and friends full episodes - YouTube:



'via Blog this'

Learn F# in Y Minutes

Learn F# in Y Minutes:



'via Blog this'

Loosetooth.com = Brandy Agerbeck = graphic facilitator + artist. Graphic facilitation, graphic recording, visual facilitation, scribing, drawing, printmaking, sewing, quilting, crafting.

Loosetooth.com = Brandy Agerbeck = graphic facilitator + artist. Graphic facilitation, graphic recording, visual facilitation, scribing, drawing, printmaking, sewing, quilting, crafting.:



'via Blog this'

The Idea Shapers | Drawing as your best thinking tool by Brandy Agerbeck — Kickstarter

The Idea Shapers | Drawing as your best thinking tool by Brandy Agerbeck — Kickstarter:



'via Blog this'

Chris Piascik - The Illustrator Formerly Known as Designer

Chris Piascik - The Illustrator Formerly Known as Designer:



'via Blog this'

Creating Social Network on Ruby on Rails – Day 1 – System Setup | A Big Bang Hash

Creating Social Network on Ruby on Rails – Day 1 – System Setup | A Big Bang Hash:



'via Blog this'