Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
geminihzh
Valued Contributor

isNull(fieldName) is true if select more than one value from fieldName

Hi, all, I am confused of using IsNull here when I use IsNull() to check whether there value from a fieldName is selected or not.

I can understand that if no selection of fieldName, then IsNull(fieldName) is true, but when I select more than one value from the fieldName, the result is also true, which I expect be false.

If that is the case, then how can I identify there is no selection of a field? I need to use the result as a condition to show other object.

Thank you very much~

Tags (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: isNull(fieldName) is true if select more than one value from fieldName

Hi,

Try this GetSelectedCount(fieldName) > 0

Aurélien

View solution in original post

3 Replies
Partner
Partner

Re: isNull(fieldName) is true if select more than one value from fieldName

Hi,

Try this GetSelectedCount(fieldName) > 0

Aurélien

View solution in original post

Luminary
Luminary

Re: isNull(fieldName) is true if select more than one value from fieldName

isNull(FieldName) will evaluate to True and is working as designed.

Reason being is that for one row (or in a textbox) FieldName will have multiple values (if you select more than one value). Since FieldName is not deterministic (it can have more than one value) it returns null() or '-'. IsNull() of null() is true.

If you wish to identify if there are no selections in a field, use GetSelectedCount(Fieldname)=0 as Aurelien suggested.

geminihzh
Valued Contributor

Re: isNull(fieldName) is true if select more than one value from fieldName

@Martin,

It works!!! Thanks very much for your explanation.

Zhihong