Remove dimension from bar chart

[#1]

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

[swuehl]

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]

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.

[sunny_talwar]

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]

chk dis

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

Excluding values in Set Analysis