Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
gwmills_fiserv
Partner
Partner

Load just specific data

I am creating a chart with branches as my dimension across the bottom.  I want to limit the dimension to show all branches except branch 500 and branch 600.   I do not wan this to be a filter, as I the user to be able to select specific branches for further details, but when the filter is cleared, I want to continue to exclude numbers 500 and 600.

 

 

Labels (4)
1 Solution

Accepted Solutions
OmarBenSalem
Partner
Partner

change ur measure from :
sum(Measure)
to
sum({<Branch-={'500','600'}>}Measure)

View solution in original post

5 Replies
OmarBenSalem
Partner
Partner

change ur measure from :
sum(Measure)
to
sum({<Branch-={'500','600'}>}Measure)

View solution in original post

gwmills_fiserv
Partner
Partner
Author

It is not a measure, but rather the dimension across the bottom.

 

OmarBenSalem
Partner
Partner

an u share your chart?

Chart type?

Dimensions and measures used?

and an image maybe?

 

gwmills_fiserv
Partner
Partner
Author

Sure.   

Combo Chart.   Bottom is Branch, Left Side Balance, Right side Rate info.

Capture.JPG

dilipranjith
Partner
Partner

Solution mentioned by Omar will work and using set analysis (i.e. giving logic in expressions) is the best approach Unless some other restriction which we i dont know of.

Or you can use if condition on the dimension level on chart as well but i wouldn't recommend it