Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

See table only after filters application

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

3 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

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?

Not applicable
Author

I apologize for my question, I found the box where I can insert the text!

Thanks again!