QlikView App Dev

[#1]

Hi,

I am new to qlikview.

My requirement is that I wish to show data in a chart for current date as well as data on date of last weekend.

I can show easily data for current date, but how to calculate data for last weekend?

I am having personal edition of qlikview so can't open any external files.

Can anyone please paste here function?

Thanks in advance.

[#2]

You will likely want to use either some if() statements or Set Analysis for your calculation, but the function you are looking for would be something like: =num(weekday(Datefield)) which will return a value between 0-6. 5 & 6 being Saturday & Sunday.

[#3]

Can anyone please paste here code to calculate sum(orders) on last weekend (of max(date)) with respect to max(date)?

my date is in yyyy-mm-dd format