Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

pkpandey
New Contributor II

Getting the Groupname of a selected item

Hi Everybody

I have three fields in a table like :

Itemname   Groupname  Quantity

A                    X               120

B                    X               230

C                    Y               325

D                    Y               258

Is it possible to get the Groupname of an item selected in the listbox.

12 Replies

Re: Getting the Groupname of a selected item

Sure can

You can use Only(Groupname) to get the value for groupname when a itemname is selected

balrajahlawat
Esteemed Contributor

Re: Getting the Groupname of a selected item

may be this as well?

=GetFieldSelections(Groupname)

Re: Getting the Groupname of a selected item

If you are selecting on itemname, how would you see a result for GetFieldSelections(Groupname)? It will only work, if you have selected something in Groupname.

balrajahlawat
Esteemed Contributor

Re: Getting the Groupname of a selected item

Okay, got it. Association will not work with GetFieldSelections()

Re: Getting the Groupname of a selected item

Nope it won't. Concat is the other option which can be used, but I feel Only() is doing exactly what the OP wants, then why look for longer alternatives

pkpandey
New Contributor II

Re: Getting the Groupname of a selected item

I have made one chart and trying to change the color of the bars which belongs to the group of item

selected.

On Mon, 01 Feb 2016 17:32:24 +0530 Sunny T wrote

Getting the Groupname of a selected item

reply from Sunny T in QlikView Deployment - View the full discussion

Nope it won't. Concat is the other option which can be used, but I feel Only() is doing exactly what

the OP wants, then why look for longer alternatives

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in QlikView Deployment by email or at Qlik Community

Following Getting the Groupname of a selected item in these streams:

Inbox

© 1993-2015 QlikTech International AB |

Copyright & Trademarks | Privacy | Terms of Use | Software EULA

pkpandey
New Contributor II

Re: Getting the Groupname of a selected item

Thank you for your quick reply.

I am trying to change the color of the bars in a bar chart of all the items of the group of item

selected in a list box.

On Mon, 01 Feb 2016 17:30:23 +0530 Balraj Ahlawat wrote

Getting the Groupname of a selected item

reply from Balraj Ahlawat in QlikView Deployment - View the full discussion

Okay, got it. Association will not work with GetFieldSelections()

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in QlikView Deployment by email or at Qlik Community

Following Getting the Groupname of a selected item in these streams:

Inbox

© 1993-2015 QlikTech International AB |

Copyright & Trademarks | Privacy | Terms of Use | Software EULA

pkpandey
New Contributor II

Re: Getting the Groupname of a selected item

Thank you for your quick reply.

Please find the attached application. I want to change the color of the bars of the same group of the

selected item in the list box.

Please help.

On Mon, 01 Feb 2016 17:32:24 +0530 Sunny T wrote

Getting the Groupname of a selected item

reply from Sunny T in QlikView Deployment - View the full discussion

Nope it won't. Concat is the other option which can be used, but I feel Only() is doing exactly what

the OP wants, then why look for longer alternatives

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in QlikView Deployment by email or at Qlik Community

Following Getting the Groupname of a selected item in these streams:

Inbox

© 1993-2015 QlikTech International AB |

Copyright & Trademarks | Privacy | Terms of Use | Software EULA

Re: Getting the Groupname of a selected item

Can you share a sample?

Community Browser