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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

not to affect selection other than one field

i want to create a chart which shows total sum of sales till date for the region which is selected. But i donot want the chart to be affected with other fields selection except Region, How to do that? If i use alternate state then region selection will not reflect but i want region to be affected but other field selection should not affect.

3 Replies
sunny_talwar

Try this in your set analysis

{1<Region = p(Region)>}

Anonymous
Not applicable
Author

But sum({1<Region={p(Region)}>Sales) it shows error

sunny_talwar

Try this:

Sum({1<Region = p(Region)>} Sales)