Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rainstorm9
Contributor
Contributor

Pivot Table Selection

I have a pivot table like this (row: region, rank; column: sales category; measure: sum of sales)

When user makes a selection on the state, I want to still show all rows instead of just the state selected. I have other filters that I still want to keep and filter this pivot table. I have tried to use 

sum({<State=>}Sales) as my measure but it doesn't work. Please help if there is any other solutions!

Capture.PNG

 

Labels (4)
1 Reply
joseph_morales
Creator II
Creator II

Hi @rainstorm9,

Having the 3 dimensions: State, rank and category, I didn't find any problem with the expression, except if you select Rank, it is filtered for the corresponding State.
You may have filters that have unique values for each of the State.

Could you provide an example of data and what dimensions are you using as filters?

 

Best Regards,
Joseph Morales