Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Luminary Alumni
Luminary Alumni

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
Author

Try this

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

Not applicable
Author

hi,

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


Regards,

Guru

IAMDV
Luminary Alumni
Luminary Alumni

Guru,

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

Cheers - DV

Not applicable
Author

use expression like this:

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

here 100 is the value for total