Remove null

[priyarane]

How to remove null as attached, when I check suppress null then my TOTAL also going off.

[#2]

Hi Priya, the suppress nulls options will affect your total too, as it is a chart wide setting. This is working as expected from what I can see.

Maybe post up an example of your expected output and some dummy qvw, this may be achievable in a different way from that setting alone

thanks

Joe

[jsingh71]

Share some sample data or app then it will easy to give solution.

[marcus_malinow]

Priya,

o echo what Joe said - without something to work on which illustrates this issue (i.e. a document you upload), we're all flying blind here so no one will be able to be of much help.

Have you tried changing the Total Mode of your expression?

Marcus

[miguelbraga]

If you can't give a sample qvw, can you please give as an Excel file so that we can recreate your solution and attached it in here

[Anonymous]

Hi,

i think, without more information from you, advice to add a condition to the expression.

object properties --> Expression --> check "conditional" --> add your conditional expression

Regards