Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting - instead of 0 or 1

=IF($(=Concat(DISTINCT ‘GetSelectedCount(‘ & $Field & ‘)’, ‘ + ‘)) = 0, 1, 0)

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

This will give you a count of the current selections:

=$(=concat('getselectedcount([' & $Field & '])','+'))

But if you only want to know if there are any selections, try: if(len(getcurrentselections)),1,0)


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
sivarajs
Specialist II
Specialist II

Try this IF(Concat(DISTINCT GetSelectedCount($Field), '+') = 0, 1, 0)

Not applicable
Author

Thanks but it is only showing 1and never 0

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

This will give you a count of the current selections:

=$(=concat('getselectedcount([' & $Field & '])','+'))

But if you only want to know if there are any selections, try: if(len(getcurrentselections)),1,0)


talk is cheap, supply exceeds demand
Not applicable
Author

Great it works.I wanted to get if there are any selections or not.

Regards,

Gaurav