topic Re: How to convert dimension expression to load script expression ? in QlikView

How to convert dimension expression to load script expression ?

paulyeo11 — Fri, 05 May 2017 06:48:52 GMT

Hi All

I have field name = aging_ar

This field have number from 1 to 360

I like to create a new filed name = aging_ar_class

which is

1=1-30

2=31-60

3=61-90

In chart dimension expression below working fine :-

=If(aging_ar >= 1 and aging_ar <= 30, Dual('1-30', 1),

If(aging_ar >= 31 and aging_ar <= 60, Dual('31-60', 2), Dual('>61', 3)))

I have try convert the above expression to below for load script expression :-

If(aging_ar >= 1 and aging_ar <= 30, Dual('1-30', 1),

If(aging_ar >= 31 and aging_ar <= 60, Dual('31-60', 2), Dual('>61', 3))) as aging_ar_class,

it does not work , Hope some one can advise me.

Paul

jonathandienst — Fri, 05 May 2017 06:56:40 GMT

Looks OK to me. What is it doing incorrectly?

The conditions may fail if the ages are computed and are not integers. Modify it to this:

If(aging_ar < 1, Dual('0', 0),

If(aging_ar <= 30, Dual('1-30', 1),

If(aging_ar <= 60, Dual('31-60', 2),

Dual('>61', 3)))) as aging_ar_class,

to guarrantee a value in every row.

rahulpawarb — Fri, 05 May 2017 06:56:42 GMT

Hello Paul,

May be try below:

If(aging_ar >= 1 and aging_ar <= 30,
   '1-30',
   If(aging_ar >= 31 and aging_ar <= 60,
   '31-60',
   '>61')) AS aging_ar_class

Regards!

Rahul

paulyeo11 — Fri, 05 May 2017 07:08:14 GMT

Hi Rahul

Wow you are good. Thank you very much.

Paul Yeo

rahulpawarb — Fri, 05 May 2017 07:16:43 GMT

Cheers,

Rahul