7 Replies Latest reply: Nov 16, 2017 6:46 PM by Luis Madriz RSS

    Ignore Dimension or Filter

    Ryan Metcalf

      How do I develop a chart so that it ignores a filter selection and the filter's associated dimension in Qlik Sense?  I know this can be done with measures by using set analysis.  However, I haven't found a way to do set analysis on a dimension.

       

      I have global filters in my app however I want some of them ignored on a chart in one of my sheets.  How do accomplish this?

        • Re: Ignore Dimension or Filter
          Sunny Talwar

          What is your dimension?

            • Re: Ignore Dimension or Filter
              Ryan Metcalf

              I have a dimension (Equipment) in my data model that does not have a direct relationship with a measure (Operator Average).  However, there is a common dimension (Date) between Equipment and Operator Average in the data model.  Which is to say there are common dates where Equipment and Operator Average have data.

               

              In visualizations using Operator Average I want the Equipment selection to be ignored.  Currently I am using the following expression:

              sum({<EquipmentName=>}OperatorSuccessCount)/sum({<EquipmentName=>}OperatorTotalCount)

               

              However, my box plot visualization (Qlik Sense 3.2) has a Date dimension using this expression and it is still responding to the EquipmentName selection.

               

              What I need is an expression that not only ignores the EquipmentName filter but also ignore the dates associated with EquipmentName, and returns the dates based on all the other filter selections.

            • Re: Ignore Dimension or Filter
              Luis Madriz

              Hi Ryan, I'm not the best with set analysis but I think you can do this by "resetting" the value of the dimensions you need to be dismissed. Please notice in the pivot table at the bottom of the screenshot that one measure uses a set analysis to dismiss any selection of the SessionYear and the other doesn't.

               

              Please let me know if this helps, if not, just share what you have and the behaviour you expect and I'm positive you'll get an answer from the gurus on the Community.

               

              Cheers,

               

              Luis

               

              Untitled.png

                • Re: Ignore Dimension or Filter
                  Ryan Metcalf

                  I have a dimension (Equipment) in my data model that does not have a direct relationship with a measure (Operator Average).  However, there is a common dimension (Date) between Equipment and Operator Average in the data model.  Which is to say there are common dates where Equipment and Operator Average have data.

                   

                  In visualizations using Operator Average I want the Equipment selection to be ignored.  Currently I am using the following expression:

                  sum({<EquipmentName=>}OperatorSuccessCount)/sum({<EquipmentName=>}OperatorTotalCount)

                   

                  However, my box plot visualization (Qlik Sense 3.2) has a Date dimension using this expression and it is still responding to the EquipmentName selection.

                   

                  What I need is an expression that not only ignores the EquipmentName filter but also ignore the dates associated with EquipmentName, and returns the dates based on all the other filter selections.

                    • Re: Ignore Dimension or Filter
                      Luis Madriz

                      Hi Ryan,

                       

                      Did you try just adding the date field in the measure on your box plot? {<EquipmentName=>,<Date=>}


                      Cheers,

                       

                      Luis



                        • Re: Ignore Dimension or Filter
                          Luis Madriz

                          Sorry, I just tried it my self and doesn;t work {<EquipmentName=, Date=>}

                           

                          I'll keep trying,

                           

                          Sunny, welcome any comment!

                           

                          Cheers,

                           

                          Luis

                            • Re: Ignore Dimension or Filter
                              Luis Madriz

                              Ok, I think I got it.

                               

                              I have QS June 17 where you can edit the expressions used in every part of the box. I hope it't the same for you.

                               

                              I edited ALL the expressions to reset the EquipmentName, well in my case it was MDC

                              =(Avg({<MDC=>} total <[MDC]> Aggr( Count({<MDC=>} separations_int), [MDC], [Separation_Date] )  ) - 2 *(Stdev( {<MDC=>} total <[MDC]> Aggr( Count({<MDC>} separations_int), [MDC], [Separation_Date] )  ) ))

                               

                              So I added {<MDC=>} to all the which in your case is {<EquipmentName=>} to all the aggregation functions I saw:

                              Avg, Count, Stdev, etc.


                              This is a large data set and every change took a while to respond so I didn't test if anything changed. But at least I could check that when I selected a MDC, the box plot didn't change.


                              I hope this helps,


                              Cheers,


                              Luis