Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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