How can we replace NULL values with NA in Qlikview straight table?

datavisualization
qlikview
missing_values

#1

Hi,

I am creating a dashboard in Qlikview and using straight table to represent one of the top 5 mangers on sales with their demographics detail but all the demographics detail are not available for everyone. By default Qlikview is showing “-” where missing values occurs. I want to change “-” to “NA”. Please help me to perform this, is there any option available in properties or need to play with some existing options.

Thanks,
Steve


#2

@Steve,

There is an option in Qlikview to represent missing and NULL values in table. Go to chart properties --> Presentation Tab --> Below You can see the relevant option.

Hope this helps!

Regards,
Sunil