Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
=if(isnull(GetFieldSelections(LAND)),1,0)
Enjoy your Qlik.
Kind regards,
Théo ATRAGIE.
Try this
=if(isnull(GetFieldSelections(LAND)),1,0)
Enjoy your Qlik.
Kind regards,
Théo ATRAGIE.
Hello, you can use this :
if(len(GetFieldSelections(LAND))>=1 ,0,1)
"-" 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