topic Re: Rename Null Value Using A Calculated Dimension in QlikView

Rename Null Value Using A Calculated Dimension

Thu, 11 Apr 2013 19:26:42 GMT

In a straight table, how do I replace '-' for null value with the word 'Unlisted'?

Example:

Current output

Dimension Revenue

John $20

Brian $100

Fred $45

- $5

Proposed output

Dimension Revenue

John $20

Brian $100

Fred $45

Unlisted $5

Re: Rename Null Value Using A Calculated Dimension

Gysbert_Wassenaar — Thu, 11 Apr 2013 19:41:34 GMT

Try if(len(trim(Dimension))=0,'Unlisted',Dimension)

But it's better to do this in the script. That will give better performance in the charts. And nulls cannot be selected so replacing nulls with real values if possible is always a good idea.

Re: Rename Null Value Using A Calculated Dimension

Wed, 17 Apr 2013 03:09:38 GMT

I agree with Gysbert, probably better to move this to the import script. This would also work on import:

if(isnull(Dimension),'Unlisted',Dimension) as Dimension

Best,

Matt

Re: Rename Null Value Using A Calculated Dimension

jagan — Wed, 17 Apr 2013 05:58:20 GMT

Hi,

If you need this in all the charts then you should do this in script itself, because the calculated dimension has performance issues. As matt suggested do this in the script by using

LOAD

If(IsNull(DimensionName), 'Unlisted', DimensionName) AS DimensionName

FROM Source;

Hope this helps you.

Regards,

Jagan.