Hide null in bar chart but keep in total calculation

[retko1985]

Hello,

please see the picture of my bar chart:

I want to hide the DASH, but if I check "Supress When Value Is Null" then the TOTAL amount changes, which I dont want.

Can you help me here please?

Thank you.

[Anil_Babu_Samineni]

May be create dimension field

If(Not IsNull(Category), Category)

[retko1985]

unfortunately makes no difference.

[Anil_Babu_Samineni]

I even no that, But are you adding Total using Pick (Dim,....) with the dimension. Not sure, Why TOTAL changing. Can you attach sample

[jonathandienst]

I expect that your problem lies in the data model, I suggest that you upload a small sample qvw with some representative data and the chart object/ The data need not be real, but the sample data should have the same structure.

[retko1985]

So I made an model document with dummy data, see attached QVW.

So what I want is not to display the NULL category, but keep the sum of TOTAL to 61.

Thank you.

[pradosh_thakur]

61 or 161?

can you tell what is your expected output?

[parthesh]

HEllo,

    Please check attached QVW.

[Or · Accepted solution]

I'm more than a little lost as to why you want a bar chart with a total in it, but I guess that's what you want...

[Frank_Hartmann]

see attached file.

hope this helps