topic Re: Getting - instead of 0 or 1 in QlikView

Getting - instead of 0 or 1

Thu, 24 Jan 2013 06:16:51 GMT

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

sivarajs — Thu, 24 Jan 2013 06:24:30 GMT

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

Thu, 24 Jan 2013 06:39:59 GMT

Thanks but it is only showing 1and never 0

Gysbert_Wassenaar — Thu, 24 Jan 2013 09:56:45 GMT

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)

Thu, 24 Jan 2013 10:47:30 GMT

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

Regards,

Gaurav