Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Remove dimension from bar chart

Hi Qlik Community,

I'm creating a bar graph summing sales over different business areas

In the spreadsheet, if the business areas are "A", "B", "C" and "Not filtered" how can I set up the bar chart so that it ignores Not Filtered values and doesn't display it as a category on the x-axis? (Without having to set up a filter panel each time, preferably something with the dimension function)

Cheers,

Chris

Tags (2)
4 Replies
MVP
MVP

Re: Remove dimension from bar chart

Try a calculated dimension like

=If( BusinessArea <> 'Not filtered', BusinessArea)

Alternatively, use set analysis in all your expressions:

=Sum({<BusinessArea -= {'Not filtered'}>} Value)

edit: You may need to adapt the options that control showing NULL values for the dimension in chart properties

zhadrakas
Valued Contributor

Re: Remove dimension from bar chart

Hello Christopher,

you can use a calculated Dimension:

IF(Business_Area<>'Not filtered', Business_Area)

but i think it would be better do do it in script. There you can build a new field of Business Area without the "Not Filtered" Values.

Re: Remove dimension from bar chart

You can also do like this:

=Sum({<BusinessArea = {'A', 'B', 'C'}>} Value)


or


=Sum({<BusinessArea *= {'A', 'B', 'C'}>} Value)

First expression will always show all three Business Area regardless of selection in BusinessArea field. Whereas second option will filter out those which are not selected while always excluding Not Filtered.

Chanty4u
Esteemed Contributor III

Re: Remove dimension from bar chart

chk dis

=sum({<[BussinesArea]-={'Value'}>}sales)

Excluding values in Set Analysis