Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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.

 

 

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Load just specific data

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

View solution in original post

5 Replies
Highlighted
Partner
Partner

Re: Load just specific data

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

View solution in original post

Highlighted
Partner
Partner

Re: Load just specific data

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

 

Highlighted
Partner
Partner

Re: Load just specific data

an u share your chart?

Chart type?

Dimensions and measures used?

and an image maybe?

 

Highlighted
Partner
Partner

Re: Load just specific data

Sure.   

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

Capture.JPG

Highlighted
Partner
Partner

Re: Load just specific data

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