Date and order both null it is shwoing '-' . how to show it as 0

[Abhi999]

I have tried len, alt everything because of date and order both are null getting '-' how make it as 0 in qlik sense pivot.

[QFabian]

Hi  @Abhi999 , if you are using a field called 'Date' as Dimension, you can modify that field in your script, using for example :

if(isnull(Date), 0, Date)  as Date

And in case of expressions in charts you can do somthing like this :

if(isnull(sum(field)), 0, sum(field)

But important too i think, is understand if you wnt to show zeros or supresed rows with no Data.

For the Date as dimension case, maybe you can check the "include null values" propertie.

And in case of one expression, you can check the "Add-ons\Data Handling\Include Zero values" propertie.

[Ksrinivasan]

hi,

try this

ALT function.

ksrinivasan

[Abhi999]

still getting '-'

[Ksrinivasan]

hi,

can you share any one of the measure expression wrt to dimension,

ksrinivasan

[Rodj]

Your measure is returning a null value. You can address this at a number of places depending on how your app is constructed and what your data management principals are. Personally I always prefer to show the '-' as it is meaningful that this is a null value and purely a presentation affectation to put a 0 there instead when that isn't  the true result. If you want to pretend that a null is instead 0 then you can use an if statement in your measure to detect and replace it, eg.

if(isnull(sum(myMeasure)), 0, sum(myMeasure))

Depending on how your app is structured and the nature of your measure you may be able to create rows in your load script to create 0 values. 

[Ksrinivasan]

hi,

try this

ksrinivasan

[Abhi999]

Previously I use count (orders)

Date is dimension but I am converting date and time into numbers like 0 to 23.

0 - 12 to 1 AM

.

.

23- 11  to 11:59:59 pm.

[Abhi999]

I have tried all this initial stage no use getting '-'.