Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Giselle100
Contributor III
Contributor III

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
sunny_talwar

May be you need this

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

View solution in original post

7 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Giselle100
Contributor III
Contributor III
Author

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

sunny_talwar

May be you need this

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

View solution in original post

Gysbert_Wassenaar

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
sunny_talwar

Hey Gysbert -

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

Thanks, worked perfectly

Giselle100
Contributor III
Contributor III
Author

This worked perfectly, thanks