Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
aaronnayan
Contributor III

Text box - current selections

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?

1 Solution

Accepted Solutions
Partner
Partner

Re: Text box - current selections

Sorry, my mistake try below expression

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

View solution in original post

10 Replies
Partner
Partner

Re: Text box - current selections

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.

Re: Text box - current selections

Include them how? May be this?

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

Re: Text box - current selections

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
aaronnayan
Contributor III

Re: Text box - current selections

there is an error in this expression krishna

aaronnayan
Contributor III

Re: Text box - current selections

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

Partner
Partner

Re: Text box - current selections

Please try this

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

aaronnayan
Contributor III

Re: Text box - current selections

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

aaronnayan
Contributor III

Re: Text box - current selections

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

Partner
Partner

Re: Text box - current selections

Sorry, my mistake try below expression

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

View solution in original post