topic Re: 0 Missing in QlikView

0 Missing

priyarane — Wed, 04 Nov 2015 08:23:08 GMT

Hi Community,

0 is missing as attached possible value is 0% only.

Re: 0 Missing

Anonymous — Wed, 04 Nov 2015 08:24:51 GMT

Share the sample data.

Re: 0 Missing

priyarane — Wed, 04 Nov 2015 08:26:41 GMT

Hi Balraj, This is huge application and not possible to shar.. Could you please help me in front end

Re: 0 Missing

Anonymous — Wed, 04 Nov 2015 08:31:12 GMT

Well,

Check out the Number format of RWA%, you can select Show in percentage option

Re: 0 Missing

priyarane — Wed, 04 Nov 2015 08:37:17 GMT

same option selected

Re: 0 Missing

Anonymous — Wed, 04 Nov 2015 08:39:18 GMT

well, then I need sample data.

See if you can create Inline and share it?

Re: 0 Missing

Anonymous — Wed, 04 Nov 2015 08:40:13 GMT

share the metrics of RWA%

Re: 0 Missing

sujeetsingh — Wed, 04 Nov 2015 08:41:27 GMT

Priya this seems that there are some nulls due to your expression hence try using len(complete expression)=0,0,Expression).

Many times the expressions give such output like Sum/Total here if Total is there and sum is 0 then it is always null

Re: 0 Missing

jagan — Wed, 04 Nov 2015 08:42:21 GMT

Hi,

Is it 0 or Null in that rows? If there are Null values then it shows empty values. Can you try using Alt() like below

LOAD

Alt(RWA, 0) AS RWA,

FROM SourceTable;

Hope this helps you.

Regards,

Jagan.

Re: 0 Missing

Anonymous — Wed, 04 Nov 2015 09:51:44 GMT

Hi Jagan,

What is the advantage of ALT() function?

I tried to fined out in QV help but did not get what exactly it does?

Re: 0 Missing

jagan — Wed, 04 Nov 2015 09:57:08 GMT

Hi Balraj,

If there is null value Alt function will return the second parameter. For example

Alt(CLOSED_DATE, Today())

If CLOSED_DATE is Null then Alt() will return Today's date.

Hope this helps you.

Regards,

jagan.

Re: 0 Missing

Anonymous — Wed, 04 Nov 2015 10:06:50 GMT

Okay, so it handles null values. If Closed_Date is null then Today() is the alternate value of it...

Re: 0 Missing

jagan — Wed, 04 Nov 2015 10:45:33 GMT

Yes. Similar NVL() in oracle.

Regards,

Jagan.