Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to show a table just when result is not null?

Hello,

I have a table whose values ​​are calculated according to certain rules.

In some months these rules do not apply and the result is null.

How can I do  the table does not appear when this result is null?

Thank you!

3 Replies
tresesco
MVP
MVP

In the layout tab-> Show->Conditional

There, write your condition like = If (Month= 'Jan' Or  Month='Mar')

Not applicable
Author

but the result depends on many factors and I don't know when the displayed results are void, so, i can't  use the mouth as a variable.

I need that after the result is calculated, if it is null, the table is not displayed.

would be something like "if resultset is null"

tresesco
MVP
MVP

Object can't be referred to see if it returns null or not. You have to have some logical expression for your 'resultset'. And then you can try something like : =IsNull( yourlogical expression)