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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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)