Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Hide one of the bars

Attached is the picture of my graph where i want to hide '-' and 'did not use' Bars so the total number will add up to 100 for satisfaction

VERY VERY IMPORTANT

2 Replies
brindlogcool
Contributor III

Re: Hide one of the bars

You can hide this '-' column by  enabling the option  Supress when the value is null.Refer the attached image.

Either you using calculated dimension or your column has a null value.

Re: Hide one of the bars

HI

In Dimension tab

tick -> Suppress When Value is Null

Expression

=Sum({<FieldName -= {'*did not*'}>}Count)/Sum({<FieldName -= {'*did not*'}>}total Count)

Hope it helps

Community Browser