Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: See table only after filters application

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

3 Replies
baruchjacob
New Contributor III

Re: See table only after filters application

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

Re: See table only after filters application

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

Re: See table only after filters application

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

Thanks again!