Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pkpandey
Contributor III
Contributor III

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
sunny_talwar

Sure can

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

Anonymous
Not applicable

may be this as well?

=GetFieldSelections(Groupname)

sunny_talwar

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.

Anonymous
Not applicable

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

sunny_talwar

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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

sunny_talwar

Can you share a sample?