5 Replies Latest reply: Jul 30, 2015 11:53 AM by Paul Roberts Branched from an earlier discussion. RSS

    Qlik Sense Filters

      If i have a table, that has 3 fields in, Computer Name, Installation Data and Group Name, how can i filter the table to show a count of installations by computer name, by group ?

       

      I can build my table to show count by computer name, but i need to filter this by a certain group name,so how would i filter the table below to only show Group A entries?


      I tried adapting Brian's set analysis expression from https://community.qlik.com/message/834250?et=watches.email.thread#834250 for this but didn't work.

       

      Thanks

       

       

       

      example:

       

      Computer Name               Installation Date               Group Name
      TGF-098                              12/04/2015                    Group A

      TGF-093                              12/04/2015                    Group A

      TGF-012                             12/04/2015                    Group B

      TGF-011                              12/04/2015                    Group C

      TGF-087                              12/04/2015                    Group B

      TGF-014                             12/04/2015                    Group D

        • Re: Gauge filter - Basic Help for Newbie
          Michael Tarallo

          Hi Paul, thanks for your participation in the Qlik Community.

           

          I branched this to a new discussion thread. Our members will review.

           

          Regards,

          Mike T

          • Re: Qlik Sense Filters
            Brian Booden

            Hi Paul,

             

            In this case, just add another clause to your set analysis expression.  For example:

             

            Count({$<[Priority Id]={1}, [Group Name]={'Group A'}>}[Task Number])


            Note that if you are doing a text comparison, you must enclose the evaluated expression in single quotes.  For a numeric comparison, no quotes are needed.


            Hope that helps.


            Regards,

            Brian

              • Re: Qlik Sense Filters

                Brian, As always thankyou for the prompt replies and help.

                how would i just set a very simple filter on the table to just show anything related to Group A, i don't need a count function or anything just filter the table to show anything relating to Group A?

                 

                Thanks

                  • Re: Qlik Sense Filters
                    Brian Booden

                    Hi Paul,

                     

                    In this case, you don't necessarily need set analysis.

                     

                    Just drag the field Group Name onto the canvas and a filter pane will be created.  Then just select, Group A.

                     

                    It's that easy...i think

                     

                    Does that make sense?

                     

                    filterpane.png

                     

                    Regards,

                    Brian

                      • Re: Qlik Sense Filters

                        Brian, that makse perfect sense, and it does work, the only problem is users can still change the filter if they want to, and the filter is visible, i need to add a filter so that ONLY group A entries show in the table, the rest are hidden and the user cannot alter this. (but i don't want to filter other groups out at load time so this isn't an option to ONLY bring in Group A data)

                         

                        Any ideas?