Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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?