Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Disabling filtering of a dimension

I have a stacked pie chart which displays states of orders per year. My dimension is

=YEAR([Data.OrderDate])

and my measures are 

=Count({<[Data.State] = {'Open'}>} DISTINCT [Data.OrderNo]&'|'&[Data.State])

=Count({<[Data.State] = {'Closed'}>} DISTINCT [Data.OrderNo]&'|'&[Data.State])

=Count({<[Data.State] = {'Cancel'}>} DISTINCT [Data.OrderNo]&'|'&[Data.State])

My stacked vbar chart is one of many charts in the page. And I also have a filter pane which includes Order date as:

=YEAR([Data.OrderDate])

When I choose a specific year I want my stacked bar chart display all years regardless of Order date chosen, as it has never been filtered. How can I accomplish this?

Regards.

Labels (2)
10 Replies
Anonymous
Not applicable
Author

Thank you very much, everyone, for their support and work, and thank you for your solution. That works perfectly. Unfortunately, I have added the 1 value in one more brackets, which did not work for me.