Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating data onlast weekend

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 Replies
Not applicable
Author

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.

Not applicable
Author

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