topic Re: Qlik: Straight table expression issue in QlikView

Qlik: Straight table expression issue

Fri, 26 Jun 2015 13:38:40 GMT

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?

Re: Qlik: Straight table expression issue

giakoum — Fri, 26 Jun 2015 13:39:58 GMT

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

Re: Qlik: Straight table expression issue

alexandros17 — Fri, 26 Jun 2015 13:42:14 GMT

a percentage is like

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

Re: Qlik: Straight table expression issue

Siva_Sankar — Fri, 26 Jun 2015 13:50:21 GMT

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

Re: Qlik: Straight table expression issue

Anonymous — Fri, 26 Jun 2015 13:54:48 GMT

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))

Re: Qlik: Straight table expression issue

Fri, 26 Jun 2015 14:01:05 GMT

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!!

Re: Qlik: Straight table expression issue

giakoum — Fri, 26 Jun 2015 14:11:04 GMT

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