topic Re: Remove null in QlikView

Remove null

priyarane — Fri, 23 Oct 2015 07:32:26 GMT

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

Re: Remove null

Fri, 23 Oct 2015 07:55:12 GMT

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

Re: Remove null

jsingh71 — Fri, 23 Oct 2015 08:20:11 GMT

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

Re: Remove null

marcus_malinow — Fri, 23 Oct 2015 08:22:16 GMT

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

Re: Remove null

miguelbraga — Fri, 23 Oct 2015 08:22:54 GMT

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

Re: Remove null

Anonymous — Fri, 23 Oct 2015 10:06:38 GMT

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