12 Replies Latest reply: Feb 2, 2016 4:13 AM by Sunny Talwar RSS

    Getting the Groupname of a selected item

    Pradeep Kumar Pandey

      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.

        • Re: Getting the Groupname of a selected item
          Sunny Talwar

          Sure can

           

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

            • Re: Getting the Groupname of a selected item
              balraj ahlawat

              may be this as well?

               

              =GetFieldSelections(Groupname)

                • Re: Getting the Groupname of a selected item
                  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.

                    • Re: Getting the Groupname of a selected item
                      balraj ahlawat

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

                        • Re: Getting the Groupname of a selected item
                          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

                            • Re: Getting the Groupname of a selected item
                              Pradeep Kumar Pandey

                              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

                              • Re: Getting the Groupname of a selected item
                                Pradeep Kumar Pandey

                                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
                                Pradeep Kumar Pandey

                                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

                                  • Re: Getting the Groupname of a selected item
                                    Sunny Talwar

                                    Can you share a sample?

                                      • Re: Getting the Groupname of a selected item
                                        Pradeep Kumar Pandey

                                        A lot of thanks to you for your prompt reply. It is working.

                                         

                                        On Mon, 01 Feb 2016 18:47:37 +0530 Sunny T  wrote

                                                                                                                        You've received a new response to your question: Getting the Groupname of a selected item

                                        Please take a minute to log in to Qlik Community, review the responses, and mark any Helpful or Correct

                                        answers.

                                        You can mark up to two helpful answers and one correct answer.  This rewards other members for taking

                                        the time to assist you.

                                                 

                                        Best Regards,

                                        Qlik Community Management

                                         

                                         

                                             Comment by replying to this email, or go to the question on Qlik Community

                                                 

                                         

                                            No longer wish to receive these emails?  Go to your email preferences and turn off the setting for

                                        "Social activity directed at you, such as @mentions, shares, and messages".

                                                                                                                        © 1993-2015 QlikTech International AB  |

                                                     

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