Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

onur0707
New Contributor III

pivot table null values

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=' ';

pivot null.png

Please suggest any appropriate solution,

Any help will/would be appreciated.

Thanks in advance.

OY

5 Replies
agigliotti
Honored Contributor II

Re: pivot table null values

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.

onur0707
New Contributor III

Re: pivot table null values

Hello Andrea,

thank you for your comment.

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

regards;

OY

sasiparupudi1
Honored Contributor III

Re: pivot table null values

Try

Alt(Sum(CONS_QUANTITY)),0)

onur0707
New Contributor III

Re: pivot table null values

it is not working Sasidhar

sasiparupudi1
Honored Contributor III

Re: pivot table null values

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

Community Browser