Convert sql qlikview code

Anonymous — Fri, 13 Mar 2015 17:14:39 GMT

Can you please help me writing this piece of code in qlikview..

vmin = min(checkindate)

vmax= max(Checkindate)

for dates min(checkindate) to max(check in date)

{

for i=1 to duration ---duration = peek(table,0,duration)

{

v_check_in_date: = vmin+i-1;

v_sales = peek(tabe,i-1,sales);

Temp_table:

Load OR REPLACE

v_check_in_date as v_temp1,

v_sales as v_sales

from v_check_in_date,v_Sales;

}

final_table:

select check_in_date,sum(sales) from temp_table group by check_in_date;

Thanks!

Re: Convert sql qlikview code

Anonymous — Sun, 15 Mar 2015 01:48:47 GMT

You want join a date with sum(sales) in one Table?