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: 
mfarsln
Creator II
Creator II

Using set analysis on dimension in order to ignore selections

Hello,

I have an app which lists some summarized values. But in the same app i want to show the raw data that populates my summarized pivot table. So that, in the second sheet which will include the raw data table, i need to ignore the selections that have been made in the first sheet. For example;

Think this as my pivot table;

pivot1.PNG

In a second sheet i want to show all values with the filters ignored. Like this;

table1.PNG

I can't use the 'alternate states' because our company has not yet updated the qlik. And i don't have enough authorization to update either.

So i tried to use the set analysis on brands dimension. Did something like that;

aggr({1}ONLY({<brands-={""}>}brands),brands)

But it doesn't work. It's still filtered.

Labels (4)
3 Replies
dplr-rn
Partner - Master III
Partner - Master III

change to below if you want to ignore just brands filter
<brands= >
or if you want it to ignore everything
just use {1} in the set analysis

hope it helps
mfarsln
Creator II
Creator II
Author

Thanks for your answer but i already used {1} in aggr function.
aggr({1}ONLY({<brands-={""}>}brands),brands)
dplr-rn
Partner - Master III
Partner - Master III

I didnt make myself fully clear.
Why are you using aggr there? i dont believe that is required unless i am missing something
I am assuming this is a simple straight table.
I would add brand as a simple dimension and one of the other columns (measure values)
Use one of the above mentioned set analysis
sum({1} total)
or sum({brand=} total)