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

To disable one bar in a bar chart

Hi,

   I am using a bar chart with dimension having 5 values(Total,Business,Education,IT,Other) and i used Expression as Count(value)...It shows the 5 bars in a bar chart...but i need to restrict the Total bar alone and i need to get only 4 dimension values(Total,Business,Education,IT,Other)...So any one can help.!!

Regards,

Guru

5 Replies
IAMDV
Not applicable

Re: To disable one bar in a bar chart

Guru - You can use the ValueList Function (Synthetic Dimension) or you can use the calculated dimension.

Or you can use Set Analysis to ignore the Total in bar chart.

   SUM({$<Dimension -= {"Total"}>}Values)

I hope this helps!

Cheers - DV

Not applicable

To disable one bar in a bar chart

Try this

Count ( {<Dimension -= {"Total"}>} Values)

Not applicable

To disable one bar in a bar chart

hi,

    For this we need to create any variable for setting the values??


Regards,

Guru

IAMDV
Not applicable

Re: To disable one bar in a bar chart

Guru,

You don’t need any variable. You can use the Set AnalysisExpression and it should work.

Cheers - DV

Not applicable

Re: To disable one bar in a bar chart

use expression like this:

if(sum(value)<100,sum(value))

here 100 is the value for total