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'

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'

Saturday, 7 November 2015

Thursday, 29 October 2015

Monday, 26 October 2015

Wednesday, 21 October 2015

Building web apps with Rails4 and AngularJS in 15 minutes | Josh Software – Where Programming is an Art!

Building web apps with Rails4 and AngularJS in 15 minutes | Josh Software – Where Programming is an Art!: "
   Rails4CrudWithAngularjs
   <%= stylesheet_link_tag 'application', media: 'all', 'data-turbolinks-track' => true %>
   <%= javascript_include_tag 'application', 'data-turbolinks-track' => true %>
   <%= csrf_meta_"



'via Blog this'

Wednesday, 16 September 2015

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

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'