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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis - Three Months

Hi, I would like to apply set analysis to the attached table, comparing three months, per location. Thanks

Labels (1)
13 Replies
Not applicable
Author

Sorry you checked the attachment that you have sent?
Should solve the problem for your case.

MK_QSL
MVP
MVP

Create a Pivot Table

Dimension

Branch

Month

Expression

SUM([Received Amt])

Anonymous
Not applicable
Author

The table you have created does not change when selecting Location ( Branch) from the drop List !!

example: If I selected "Aug"  table should show Aug and Jul and its variation.

Anonymous
Not applicable
Author

Not solved yet !!