Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating data onlast weekend


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

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

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