Qlik: Straight table expression issue

[#1]

Hi,

We have 4-5 expressions in a straight table where one of them is a calculation of a percentage. In most cases this field shows data but for some it shows 'NA' as we have replaced the Null and missing characters '-' to show 'NA'.

Has anyone faced a similar issue?

[giakoum]

yes many times

but we cannot help you without a sample app

it is the calculation that is failing. Most likely your denominator is null or 0

[alexandros17]

a percentage is like

a/b, if b is 0 or is null the result is null so you have NA

[Siva_Sankar]

Can you upload the application with sample data? or try debuggin the expression..may be by copy pasting the expression in text box

[Anonymous]

If you dont want this you can do this, so have 0 and not null/Na:

if(isnull(b),0,if(b=0,0,a/b))

[#6]

Guys,

This is not the case!!

When I click on  the associated dimension, I get the correct data showing up. I should have highlighted this in the previous message.

This is simply wierd to me!!

[giakoum]

do you use aggr in your expression? a sample app would help otherwise it is going to be a guessing game