Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

View solution in original post

5 Replies
Highlighted
Partner
Partner

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

View solution in original post

Highlighted
Partner
Partner

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

 

Highlighted
Partner
Partner

an u share your chart?

Chart type?

Dimensions and measures used?

and an image maybe?

 

Highlighted
Partner
Partner

Sure.   

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

Capture.JPG

Highlighted
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