topic Chart properties - Expression 1 in QlikView

Chart properties - Expression 1

LadyLu — Tue, 23 Feb 2021 15:30:00 GMT

Hello,
I have a doubt.
In the attached file I show the properties of a table, which has an expression equal to 1.

What does this mean? When is it convenient to use it?
Thanks in advance

LadyLu

MayilVahanan — Wed, 24 Feb 2021 01:48:45 GMT

Its just to display all the dimension values to display it.

For ex: if you are using sum(sales) and for few rows, either sales is zero or empty, it will hide. If you are using 1, you can see all the values.

Alternatively you can use table box also.

LadyLu — Wed, 24 Feb 2021 10:22:38 GMT

Hi @MayilVahanan , thank you very much!! It's clear. 🙂

And if I have this other situation:

[Flag Titolo di Studio] can have these values: Y, N or null.

And in Chart Properties I have these conditions:

1=0 and suppress when value is null. (see the attached image Capture2.png)

What is the difference between: keeping these two conditions or removing both?

Apparently if I just keep this "suppress when value is null", I don't see the values I want.

I want to see all user values even when this flag is empty.

What do you suggest me?

Thanks a lot in advance

LadyLu