This content has been marked as final. Show 5 replies
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.