Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Partner
Partner

Re: Load just specific data

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

Re: Load just specific data

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

Re: Load just specific data

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

 

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

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