Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rajaqliks
Contributor III
Contributor III

Show last 3 months and since launch data in pivot table

Hi Experts,

i need to show last 3 months and since launch data based on filter,  and the dimension should be max weekend to 12 weekends each weekend to display last 3 months as well as since launch based on filter.

please help me i am adding qvw as well as target screen shot.

Capture.PNG

4 Replies
dplr-rn
Partner - Master III
Partner - Master III

Use expression

if(dim='Since Launch',sum(IUP),sum({<Date={">=$(=AddMonth(today(),-3))"}>}IUP))

see attached

sunny_talwar

I believe this is the right expression

If(dim = 'Since Launch',
Sum(IUP),
Sum({<Weekend = {">=$(=AddMonths(Max(Weekend), -3))"}>}IUP))

image.png

rajaqliks
Contributor III
Contributor III
Author

 hi here i need to display max weekend to last 12 weekends also

rajaqliks
Contributor III
Contributor III
Author

hi sunny need to show weekends as well please help me