This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
Seems to me that your comparison is wrong
if(GetSelectedCount(AU_IT_TOWER) = 7 or GetSelectedCount(AU_IT_TOWER) = 0 And ....
View solution in original post
Duh. Thanks Josh!
Your =7 needs to be outside the bracket GetSelectedCount(AU_IT_TOWER)=7