topic Re: Adding the units of a null dimension in App Development

Adding the units of a null dimension

Giselle100 — Sat, 16 Nov 2024 21:46:28 GMT

Hi All

My dimension is: Outscan date

My measure is: Qty

In Qliksense, how do i add the Qty of the null values of outscan date?

Eg: if(isNull[Outscan Date],sum(Qty))?

Gysbert_Wassenaar — Wed, 05 Dec 2018 13:24:11 GMT

If the Include null values option for the dimension is enabled then sum(Qty) should suffice.

Giselle100 — Wed, 05 Dec 2018 13:25:49 GMT

I need to know the difference between the values that have a date and the values that do not have a date

sunny_talwar — Wed, 05 Dec 2018 13:27:46 GMT

May be you need this

Sum(Qty) - Sum({<[Outscan date] = {"*"}>}Qty)

Gysbert_Wassenaar — Wed, 05 Dec 2018 13:27:56 GMT

total: sum(Qty)

total where Outscan Date has a value: sum({<[Outscan Date]={"*"}>}Qty)

total where Outscan Date has no value: sum({<[Outscan Date]-={"*"}>}Qty)

sunny_talwar — Wed, 05 Dec 2018 13:29:01 GMT

Hey Gysbert -

Will this really work if Outscan Date is truly null?
total where Outscan Date has no value: sum({<[Outscan Date]-={"*"}>}Qty)

Giselle100 — Wed, 05 Dec 2018 13:29:42 GMT

Thanks, worked perfectly

Giselle100 — Wed, 05 Dec 2018 13:31:25 GMT

This worked perfectly, thanks