Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi experts,
I am new to qlikview
I have loaded data from my source table. i have a field in my data i.e. DAY_DATE in yyyy/mm/dd format. The data is of one month only (november 2010). Now i want to create a mastercalender with the help of which i can calculate the yield like from 1-nov-2010 to 10-nov-2010, more specificaly say i want the data between two dates.
one more think suppose i loaded the data from one table and after some time i need to load data from another table so for that is it neccessory to load the first table again or how can we save the time of loading first table.
Is it possible to define variable without load scripts?
Please help me out.
Thanks
Sushil
Hi sushil,
this is the common example for master calender. and try it with more data instead of one month data. because u learned lot thing in that while using huge data's .
Date:
Load Date as Date,
if(Month(Date)<=3,Month(Date)+9,Month(Date)-3 ) as Month_Code,
year(Date) as Year,
month(Date) as Month,
week(weekname(Date,-13)) as Week,
day(Date) as Day
resident (Tabllename)
where year(Date) > 2007 and week(weekname(Date,-13)) < 53
;