topic Re: Conditional show in QlikView

Conditional show

Thu, 15 May 2014 14:58:58 GMT

If I conditionally show a line on a chart using this expression

GetFieldSelections(DESK)='BANK CAPITAL - GSL'

It would only show when that value is selected in the DESK field. However, I also want it to show when no value is selected in the DESK field and no value is selected in another fields called SECTOR. How would I amend the expression?

Re: Conditional show

SunilChauhan — Thu, 15 May 2014 15:04:58 GMT

GetFieldSelections(DESK)='BANK CAPITAL - GSL' or getselectedcount(DESK)=0

in layout of object properties

hope this helps

Re: Conditional show

Thu, 15 May 2014 15:10:46 GMT

That doesn't take into account the SECTOR field though.

If no selections are made in the DESK field but selections are made in the SECTOR field, your logic above would mean it would still appear. I need to ensure it does NOT appear when this happens

Re: Conditional show

its_anandrjs — Thu, 15 May 2014 15:10:52 GMT

In Layout property of the chart you can try with

If( ( GetFieldSelections(DESK)='BANK CAPITAL - GSL' or GetFieldSelections(DESK)=0 And GetFieldSelections(SECTOR)=0 ),1,0)

Re: Conditional show

Thu, 15 May 2014 15:19:23 GMT

Thanks Anand

what would be the syntax for multiple values

GetFieldSelections(DESK)='BANK CAPITAL - GSL' AND 'CDS HY'

?????