Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ignoring one dimension

Hi, i have an expression =sum({$<[Category]={'Books'} >}Sales) and i also have a filter about year. How to ignore this filter in my expression?

Labels (1)
3 Replies
sr_qlikview
Creator
Creator

sum({$<[Category]={'Books'} ,year=>}Sales)

Not applicable
Author

Unfortunately it doesn't work with chart. The problem is that i have also a chart where i have to display all the months and sum of sales for them. When i choose one month, i see now only this one month on the chart but i need to ignore it and see there all the months

sr_qlikview
Creator
Creator

it should work if you ignore the month also. can u send th sample.