How to get rid of a single value in a bar diagram

[#1]

Hello,

i have a question concerning a bar diagram. The problem about googling the answer is that i have problems formulating the question. I guess a picture says more then 1000 words, so i show you what i would like to do.

So i have a dimension and in this dimension i have a column with "empty" values. I want to "hide" this column in my diagramm. This would be the first bar plot.

Then i want a second barplot where i summarzie/aggregate all columns aside from the "empty column" and compare them.

Basically this second plot would consist of 2 columns/bars.

I would prefer to directly alter the dimension and do not change anything in the loading script (i know how to do it in the loading script, but like i said would prefer to change everything in the dimension script => create custom dimensions).

Would apreciate any help.

(btw. i think i read hiding single bars is possible with QV12 - i am still using QV11. Is this true?)

[Anil_Babu_Samineni]

Try uncheck the Total checkbox from Dimension Limits tab from your object

[#3 · Accepted solution]

Unfortunately that did not work. But i figured it out now. I just created a custom dimension with an if statement.

if(Column <> '', Column)

Worked!

[sudeepkm]

Have you checked this option?

Chart Properties> Dimensions > Suppress When Value is Null (check box)

[Chanty4u]

try this  Chart Properties> Dimensions > Suppress When Value is Null (check box)

or do the ssame in presentation tab   -->supress zero values [to be chked]

[ankali1990]

Is it null or there is a value?

If it is null use previous hints, else you could try as a custom dimension

=if(WildMatch(YOURDIMENSION, ' '), null(), YOURDIMENSION) and check also Suppress When Value is Null.

Make sure what is value like, if it is blank string ' ' is ok.

[#7]

Hello guys,

thanks for all your answers. I think i found a solution as shown above. And yes - unfortunately there is an empty String value written inside it, thats why i was not able to exclude it via the checkbox.

Cheers,

Daniel