Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Frédéricdh
Creator
Creator

GetFieldSelections

I want to test the result of GetFieldSelections, with this function:

= If (GetFieldSelections(LAND) = '-',1,0)

 

but when GetFieldSelections gives '-', the test gives 0 back, why?

 

thanks for helping

Labels (1)
1 Solution

Accepted Solutions
theoat
Partner - Creator III
Partner - Creator III

Try this

=if(isnull(GetFieldSelections(LAND)),1,0)



Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

View solution in original post

3 Replies
theoat
Partner - Creator III
Partner - Creator III

Try this

=if(isnull(GetFieldSelections(LAND)),1,0)



Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

Clement15
Creator III
Creator III

Hello, you can use this :
if(len(GetFieldSelections(LAND))>=1 ,0,1)

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

"-" is the display value for Null() and as others have responded, you need to check for a null value, 

I find a slightly clearer method to to test if selections are made in a field to be:

GetSelectionCount(LAND)

-Rob