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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mansi_dv
Contributor
Contributor

Using different Alternate states in a single pivot table

I wanted 2 seperate selections for year, the corresponding Quarter and Month. For that I created list boxes, one set with Alternate state as inherited and other as new state. The image of my selection screen is attached.

Now I want to do subtractions based upon these two different selections in a single pivot table.

How to write an expression in which I can differentiate between alternate states??

Or is there some way to create this selection screen other than using alternate states?

1 Reply
Not applicable

Hi,

Please find this link,

http://community.qlik.com/thread/57349

Regards,

Raja.