Tuesday, July 10, 2012

QlikView : Variable with SQL Statement

table1:
LET start=Today();          //Current Date
LET end=Today();          //Current Date
SQL SelectRegistrationStatisticsByDate '$(start)' , '$(end)';


Let day1 = peek('RegistrationStatus',0,'table1');
Let day2 = peek('RegistrationStatus',1,'table1');

Let day3 = peek('RegistrationCount',0,'table1');
Let day4 = peek('RegistrationCount',1,'table1');


SQL INSERT INTO tbl_Kiosk_Statistics VALUES($(day4),$(day3));

No comments:

Post a Comment