Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use 'null' in expressions

Hello,

I want to hide a chart when a field has no selection, but I have no idea what the 'null'-selection in qlikview is. The one I mention below is not working. Can someone help?

=(GetCurrentSelections(CS_ChartSelection)) NOT NULL)

Thxs

Steven

1 Solution

Accepted Solutions
swuehl
MVP
MVP

try

=GetSelectedCount( CS_ChartSelection )

View solution in original post

4 Replies
swuehl
MVP
MVP

try

=GetSelectedCount( CS_ChartSelection )

Not applicable
Author

i want to do the same thing as you here, where about do you put that expression?

Thanks

Not applicable
Author

Hey,

I looked around on this forum before I saw the reply of swuehl and I used this solution:

(len(CS_ChartSelection)=0)

worked as a charm

Not applicable
Author

Hi,

     you can try using this also.

     IsNull(GetFieldSelections(CS_ChartSelection))

     IsNull is the equivalent qlikview method to use 'null' values in expression.

Regards

Rajan