topic Re: Using If and getselectedcount in QlikView

Using If and getselectedcount

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a text object that I would like to display "Test" if there are selections made for the CostCenterCode with

getselectedcount(CostCenterCode). Otherwise, display "Space." I created the expression below and put it into the Text area of the Text Object. I am not getting just the Test or Display. I get a text with the code that I wrote. I have researched but have not found anything to resolve this issue. I hope you can help.

if(getselectedcount(CostCenterCode)<1, 'Test', 'Space');

Re: Using If and getselectedcount

trdandamudi — Tue, 09 May 2017 20:11:02 GMT

Try putting a equal (=) in the front:

=if(getselectedcount(CostCenterCode)<1, 'Test', 'Space')

Note: Also remove the colon at the end.

Re: Using If and getselectedcount

Anonymous — Tue, 09 May 2017 20:12:48 GMT

I got an error message if I do that,

Re: Using If and getselectedcount

trdandamudi — Tue, 09 May 2017 20:31:18 GMT

You need to remove the semi colon at the end:

=if(getselectedcount(CostCenterCode)<1, 'Test', 'Space')

Re: Using If and getselectedcount

Anonymous — Tue, 09 May 2017 20:35:43 GMT

Re: Using If and getselectedcount

Anonymous — Tue, 09 May 2017 20:40:34 GMT

Then you want

=if(getselectedcount(CostCenterCode)>0,'Test','Space')

The way you have it written now is less than 1.

Re: Using If and getselectedcount

Anonymous — Tue, 09 May 2017 20:42:16 GMT

Re: Using If and getselectedcount

trdandamudi — Tue, 09 May 2017 20:44:24 GMT

Then you need to re-write the code as below:

=if(getselectedcount(CostCenterCode) > 0, 'Test', 'Space')

Re: Using If and getselectedcount

Anonymous — Tue, 09 May 2017 20:59:35 GMT

It's because CostCenterCode and CostCenterName are 2 difference fields. If you want to check both you could do something like

=if(getselectedcount(CostCenterName)+getselectedcount(CostCenterCode)>0,'Test','Space')