Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I created a huge Pivot Table in Qlik Sense and I've got a lot of dimensions. I don't want to see them all and I use some filters to reduce the table and see only the rows that I want. Is it possible to hide the table when I open the application and see it only after the application of the filters?
Thanks a lot to everybody!
Best regards
Nicolò Cogno
in the table properties window Under Add-ons-> Data handling
you can fill formula in the calculation condition:
for the desired filter fields:
getselectedcount(field1) >0 and getselectedcount(field2) and ...
then you will see the table after the users filter the desired fields
in the table properties window Under Add-ons-> Data handling
you can fill formula in the calculation condition:
for the desired filter fields:
getselectedcount(field1) >0 and getselectedcount(field2) and ...
then you will see the table after the users filter the desired fields
Thanks a lot! That's exactly what I was searching for!!
Last question: before the table appears I see "Calculation condition is not satisfied", is it possible to edit that text?
I apologize for my question, I found the box where I can insert the text!
Thanks again!