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: 
Anonymous
Not applicable

Ignore Dimension or Filter

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?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Luis,

I decided to implement the Sense Navigation extension to solve this problem.  It gives us the results and functionality we want.  Thanks for offering up your solution.

Ryan

View solution in original post

10 Replies
sunny_talwar

What is your dimension?

luismadriz
Specialist
Specialist

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

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

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.

luismadriz
Specialist
Specialist

Hi Ryan,

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


Cheers,

Luis



luismadriz
Specialist
Specialist

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

I'll keep trying,

Sunny, welcome any comment!

Cheers,

Luis

luismadriz
Specialist
Specialist

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

luismadriz
Specialist
Specialist

Hi,

Just wondering to know how did you go,

Cheers

Luis

When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others

Anonymous
Not applicable
Author

I haven't tried your solution yet.  I've had work on other things regarding my project.  When I get back to this issue I'll let you know.