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