Discussion board where members can get started with Qlik Sense.
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(Trim(CONS_QUANTITY) = '', null(), Sum(CONS_QUANTITY))
for the script side, I have also tried below code but also not worked.
set NullValue=' ';
Please suggest any appropriate solution,
Any help will/would be appreciated.
Thanks in advance.
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.
thank you for your comment.
Do you know is there any custom extension for this purpose?
it is not working Sasidhar
May be change the null symbol in the presentation from'-' to ''