topic Re: simple calculated dimention in QlikView

simple calculated dimention

Tue, 06 Jan 2015 10:39:06 GMT

Hi all,

i have two fields with code and Descption values..

I want to show Descption dimentional value as "Others" where code = blank or null.

So i have written below calculated dimention,but it will not give correct value.

=if(isnull(Code),'Others',Descption)

Code

=====

CAC
EDE
null or blank

Descption

========

AC Power Systems
DIGITAL ENERGY

Any helpful suggestions
Thanks

ecolomer — Tue, 06 Jan 2015 10:42:40 GMT

It is possible is not null but is blank

Try with:

if(len(Code)<1, 'Others',Descption)

Tue, 06 Jan 2015 10:45:31 GMT

Hi,

I would recommend making this change in the script, as that way your 'others' description is a real field value and can be selected.

If you must use a calculated dimension though, the below should work for you

Aggr(if(isnull(Code),'others',Description),Code)

hope that helps

Joe

anbu1984 — Tue, 06 Jan 2015 10:48:51 GMT

=if(Len(Trim(Code))=0,'Others',Descption)

kamielrajaram — Tue, 06 Jan 2015 10:54:53 GMT

Hi,

Maybe this may help

if(Len(Code)<1,'Others',Description)

Regards

Kamiel

rajkumarb — Tue, 06 Jan 2015 11:00:14 GMT

Hi try this way

if(isnull(code), 'Null' others, ) AS descption