Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
Showing results for 
Search instead for 
Did you mean: 

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!



1 Reply

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