pivot table null values

[L_Hop]

Hello everyone,

I have a standart qlik sense pivot table. In pivot table some of the values are dash(-).

The requirement is to see space or zero (0) values instead of dash(-) values.

I have already uncheck the "include null values", but stil have the dash values.

I have tried below options but none of them not worked.

if(Sum(CONS_QUANTITY)=null(),' ',Sum(CONS_QUANTITY))

IF(ISNULL(Sum(CONS_QUANTITY)),' ',Sum(CONS_QUANTITY))

If(Trim(CONS_QUANTITY) = '', null(), Sum(CONS_QUANTITY))

for the script side, I have also tried below code but also not worked.

NullAsValue 'CONS_QUANTITY';

set NullValue=' ';

Please suggest any appropriate solution,

Any help will/would be appreciated.

Thanks in advance.

OY

[agigliotti]

it works as expected, because you don't have sales for those item.

In Qlik Sense there is no way to replace null symbol as in QlikView in the chart object.

[L_Hop]

Hello Andrea,

thank you for your comment.

Do you know is there any custom extension for this purpose?

regards;

OY

[sasiparupudi1]

Try

Alt(Sum(CONS_QUANTITY)),0)

[L_Hop]

it is not working Sasidhar

[sasiparupudi1]

May be change the null symbol in the presentation from'-' to ''