topic Re: IF(GetSelectedCount...) in a Text Box in QlikView

IF(GetSelectedCount...) in a Text Box

cbaqir — Thu, 06 Nov 2014 20:21:31 GMT

I have a Text object that shows the Operating % (vOpExPercent) ) vs the Target (OP_TGT) based on the associated field called AU_IT_TOWER.

This expression works perfectly for each individual tower:

$(vOpExPercent) & '% vs ' & OP_TGT

The problem I have is that I need to show a target if either all 7 Towers are selected or if none of the Towers are selected. Each year also has a different target.

I tried to accomplish this using the following expression but it doesn't work:

$(vOpExPercent) & '% vs ' & if(GetSelectedCount(AU_IT_TOWER=7) or GetSelectedCount(AU_IT_TOWER=0) and (FISCAL_YEAR='FY15'),'xx%', (OP_TGT))

Please Help! I'm stuck.

TIA,

Cassandra

Re: IF(GetSelectedCount...) in a Text Box

jduenyas — Thu, 06 Nov 2014 20:33:00 GMT

Seems to me that your comparison is wrong

if(GetSelectedCount(AU_IT_TOWER) = 7 or GetSelectedCount(AU_IT_TOWER) = 0 And ....

Re: IF(GetSelectedCount...) in a Text Box

cbaqir — Thu, 06 Nov 2014 20:35:18 GMT

Duh. Thanks Josh!

Re: IF(GetSelectedCount...) in a Text Box

Anonymous — Thu, 06 Nov 2014 20:57:01 GMT

Hi Cassandra

Your =7 needs to be outside the bracket GetSelectedCount(AU_IT_TOWER)=7