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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Enhpad
Contributor II
Contributor II

Expand row if value is NOT NULL

I'm looking for a certain type of script within an expression. 

I want the value to be included, only if the value is NOT NULL.

So for instance, I don't want the RED row 1171798 | 1000164 to be expandable since the row/value below is NULL.

If there is a value/row available, I DO want option that the row is expandable. See the green rows below.

Enhpad_0-1669731339791.png

The option: "Include NULL-values" is not an option, since I still want row 1171798 | 1000164 to show.

 

 

Labels (1)
1 Reply
Enhpad
Contributor II
Contributor II
Author

Does anyone has a solution or workaround?