Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Giselle100
New Contributor II

Adding the units of a null dimension

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))?

1 Solution

Accepted Solutions

Re: Adding the units of a null dimension

May be you need this

Sum(Qty) - Sum({<[Outscan date] = {"*"}>}Qty)
7 Replies
MVP & Luminary
MVP & Luminary

Re: Adding the units of a null dimension

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


talk is cheap, supply exceeds demand
Giselle100
New Contributor II

Re: Adding the units of a null dimension

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

Re: Adding the units of a null dimension

May be you need this

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

Re: Adding the units of a null dimension

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)

 


talk is cheap, supply exceeds demand

Re: Adding the units of a null dimension

Hey Gysbert -

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

Re: Adding the units of a null dimension

Thanks, worked perfectly

Giselle100
New Contributor II

Re: Adding the units of a null dimension

This worked perfectly, thanks