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'

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'

Monday, 21 December 2015

C#: Read and Write Excel (*.xls and *.xlsx) Files Content without Excel Automation (using NPOI and ADO.NET) - CodeProject

C#: Read and Write Excel (*.xls and *.xlsx) Files Content without Excel Automation (using NPOI and ADO.NET) - CodeProject: "adapter = new OleDbDataAdapter("SELECT * FROM " + comboBox1.SelectedItem.ToString(), conn);

new OleDbCommandBuilder(adapter);

dt = new DataTable();
adapter.Fill(dt);"



'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

Wednesday, 2 December 2015

Tuesday, 1 December 2015

RVM: Ruby Version Manager - Installing RVM

RVM: Ruby Version Manager - Installing RVM: "gpg --keyserver hkp://keys.gnupg.net --recv-keys 409B6B1796C275462A1703113804BB82D39DC0E3
"



'via Blog this'