topic Re: Text box - current selections in QlikView

Text box - current selections

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

Hi guys.

I have a text box that shows information when a certain dimension is selected

the code i have used is

=IF(ISNULL(ONLY(BRNAME)),'',ONLY(BRNAME))

However i want to include another two dimensions ("GRNAME","GBNAME")

I know this maybe very simple but could anyone help me do this please?

krishnacbe — Tue, 09 May 2017 14:29:22 GMT

Try Below Expression

IF(GetSelectedCount(BRNAME)=1, BRNAME, if(GetSelectedCount(GRNAME)=1, GRNAME, if(GetSelectedCount(GBNAME),'')

But This will work only if you have selected one value in the List box.

sunny_talwar — Tue, 09 May 2017 14:29:47 GMT

Include them how? May be this?

=IF(ISNULL(ONLY(BRNAME&GRNAME&GBNAME)),'',ONLY(BRNAME & ' ' & GRNAME & ' ' & GBNAME))

Anil_Babu_Samineni — Tue, 09 May 2017 14:30:33 GMT

I would suggest you to create composite key for required fields and then use same as you required

aaronnayan — Tue, 09 May 2017 14:34:02 GMT

there is an error in this expression krishna

aaronnayan — Tue, 09 May 2017 14:40:07 GMT

Hi Sunny only when the a value from BRNAME is selected do all the other values show

The fields work in hierarchy

GBNAME

GRNAME

BRNAME

I want it so as soon as a field is selected it will show what dimension has been selected from the 3

krishnacbe — Tue, 09 May 2017 14:40:43 GMT

Please try this

=IF(GetSelectedCount(BRNAME)=1, BRNAME, if(GetSelectedCount(GRNAME)=1, GRNAME, if(GetSelectedCount(GBNAME),'')))

aaronnayan — Tue, 09 May 2017 14:42:07 GMT

a composite key is not needed ANIL its for aethsetic purposes onlly

aaronnayan — Tue, 09 May 2017 14:44:20 GMT

Hi Krishna very very close! it just does not show GBNAME

krishnacbe — Tue, 09 May 2017 14:48:52 GMT

Sorry, my mistake try below expression

=IF(GetSelectedCount(BRNAME)=1, BRNAME, if(GetSelectedCount(GRNAME)=1, GRNAME, if(GetSelectedCount(GBNAME)=1,GRNAME,'')))

aaronnayan — Tue, 09 May 2017 14:53:14 GMT

You smashed it thankyou Krishna