Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
rmmetcalf
New Contributor III

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
rmmetcalf
New Contributor III

Re: Ignore Dimension or Filter

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

Re: Ignore Dimension or Filter

What is your dimension?

luismadriz
Valued Contributor

Re: Ignore Dimension or Filter

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

rmmetcalf
New Contributor III

Re: Ignore Dimension or Filter

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.

rmmetcalf
New Contributor III

Re: Ignore Dimension or Filter

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
Valued Contributor

Re: Ignore Dimension or Filter

Hi Ryan,

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


Cheers,

Luis



luismadriz
Valued Contributor

Re: Ignore Dimension or Filter

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

I'll keep trying,

Sunny, welcome any comment!

Cheers,

Luis

luismadriz
Valued Contributor

Re: Ignore Dimension or Filter

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
Valued Contributor

Re: Ignore Dimension or Filter

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

rmmetcalf
New Contributor III

Re: Ignore Dimension or Filter

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.