topic Text Box text should change as per Dimension selection in QlikView

Text Box text should change as per Dimension selection

pra_kale — Sat, 13 Feb 2016 14:14:35 GMT

Hi,

In a attached application in Text box I have written a below code by which I am getting channel and Target in a Text box like 'Alternate Target'. But, if nothing is selected then I want 'Overall Target' in a Text box instead of only Target.

=GetFieldSelections(Channel) & ' Target'

Please help in achieving this.

Re: Text Box text should change as per Dimension selection

sunny_talwar — Sat, 13 Feb 2016 14:17:17 GMT

Try this may be:

=If(GetSelectedCount(Channel) > 0, GetFieldSelections(Channel), 'Overall') & ' Target'

Re: Text Box text should change as per Dimension selection

pra_kale — Sat, 13 Feb 2016 15:07:28 GMT

Sunny Thanks for your Help...It is working fine.

Re: Text Box text should change as per Dimension selection

sunny_talwar — Sat, 13 Feb 2016 15:39:02 GMT

Great

Glad I was able to help