Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
mfarsln
New Contributor III

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.

3 Replies
dilipranjith
Honored Contributor

Re: Using set analysis on dimension in order to ignore selections

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
New Contributor III

Re: Using set analysis on dimension in order to ignore selections

Thanks for your answer but i already used {1} in aggr function.
aggr({1}ONLY({<brands-={""}>}brands),brands)
dilipranjith
Honored Contributor

Re: Using set analysis on dimension in order to ignore selections

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)