# Qlik Sense Advanced Authoring

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

Labels (5)

• ### Qlilsense

1 Solution

Accepted Solutions MVP

## Re: Adding the units of a null dimension

May be you need this

`Sum(Qty) - Sum({<[Outscan date] = {"*"}>}Qty)`
7 Replies 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
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 MVP

## Re: Adding the units of a null dimension

May be you need this

`Sum(Qty) - Sum({<[Outscan date] = {"*"}>}Qty)` 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 MVP

## 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)
New Contributor II

## Re: Adding the units of a null dimension

Thanks, worked perfectly

New Contributor II

## Re: Adding the units of a null dimension

This worked perfectly, thanks