topic Re: Including all values in QlikView

Including all values

smilingjohn — Tue, 08 Dec 2020 06:00:40 GMT

Hi All,

IN my data I have the values like null and empty where as I need to consider those values which are empty and null .

but this is considering only empty values or - values and neglecting something like 'null' .

Thanks in Adance

Re: Including all values

Nicole-Smith — Mon, 07 Dec 2020 17:00:43 GMT

You can join your two sets together with an OR by using + between them:
count({<ID={"=Len(Sales_ID&Employee_ID)<=0"}>+<Sales_ID={'null'},Employee_ID={'null'}>}ID)

In this case, it will count it if either of the sets are true.

Re: Including all values

Chanty4u — Tue, 08 Dec 2020 05:22:44 GMT

try this

in script: NULLASVALUE *;

in front end expression :

count({<Sales_ID={"*"},Employee_ID={"*"}>}ID)