Repalce the null values into NA in pivot table column

[Kohli]

I have pivot table. Row name is Sales, Column Name is Month .    

like

Sales        Jan .  Feb     Mar   Apr

India         200     200    300   400

USA .       300 .    -        500 . 600

UAE .       150     300    -         50

BNG .      -           70 .      40 .   -

I want replace the - values into NA.

[tresB]

In the presentation tab you can replace those missing/null values like:

[Kohli]

iam asking in Qliksense

[tresB]

If these '-'s are coming in the chart itself and not really null values in the data, I guess, you have to handle this in the script itself then. Please refer: https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/null-value-handling.htm

When null values appear in the chart because of the absence of data (not even null) in that combination in the data table, you have to somehow find an option in the chart itself to replace it in the chart itself, because there is no place holder for the same in the data table itself. And unfortunately qlik sense pivot doesn't have that option to replace/change the appearance of the 'not available' data combination in the UI. I am not sure if there is any extension that can do this. So, for me, you have to get it rectified at the script - generating a place holder, may be by joining tables.

[boraste-sagar]

Try this

if(isnull(Values), 'N/A',Values)