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

Filtering based on a referenced value

Hi,

I have data that looks something like this:

LocationWeekday SalesWeekend SalesMet Weekday TargetMet Weekend Target
A620NoYes
C315NoYes
B103YesNo
D825YesYes

To enable display of either weekday or weekend data, I have this load statement:

Selection:

LOAD * Inline "

Field, Sales, MetTarget

WeekDay, Sum([Weekday Sales]), [Met Weekday Target]

WeekEnd, Sum([Weekend Sales]), [Met Weekend Target]

";

Then I have a pie chart with:

Dimension: $(=MetTarget)

Measure: Count($(=MetTarget))


And a filter that allows me to select either Weekday or Weekend.


Problem:
If I have Weekday selected, and filter on 'Yes', then switch to Weekend, the report continues to be filtered for Weekday 'Yes'.

I would be ok with either it switching to Weekend 'Yes' or clearing the filter altogether.

Is either possible?

(I understand why it is behaving as it is, but that is not the functionality I need for this particular application)

Thank you!


0 Replies