Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
In a second sheet i want to show all values with the filters ignored. Like this;
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.