Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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)