Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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