topic Re: Calculated Dim in QlikView

Calculated Dim

priyarane — Tue, 19 May 2015 12:29:39 GMT

Hi Experts,

I have dimensions i.e., Lower bound and Higher bound it means(From, to).

Now I am using these two dimensions like first and second dimension.

But I wanted to show like one dimension as attached.

Can some pls help me.

Thank you,

Priya

Re: Calculated Dim

buzzy996 — Tue, 19 May 2015 12:33:16 GMT

if u shared some data with sample qvw ..might be tht helps to better understand ur issue and quick reply!

Re: Calculated Dim

crusader_ — Tue, 19 May 2015 12:42:54 GMT

Hi,

In your LOAD statement

create new field

FROM &' - '&TO as FromTo

Of course you can make additional formatting but in general - that's the case.

Hope this helps you.

Regards,

Andrei

Re: Calculated Dim

priyarane — Tue, 19 May 2015 12:44:17 GMT

Hi Shiva,

PFA

Re: Calculated Dim

ToniKautto — Tue, 19 May 2015 12:45:48 GMT

Perhaps the Class() function can be an option to build the ranges you have.

How to use Class() function

Re: Calculated Dim

priyarane — Tue, 19 May 2015 12:47:48 GMT

But it should come like -0 to <0.05 and if its 100 then it should looks like - 100(Default)

Re: Calculated Dim

ToniKautto — Tue, 19 May 2015 12:55:59 GMT

Look for IntervalMatch in the community or QlikView manual for examples on how you map values in grouped intervals. This way you will be able to group the values and customize the group labels.

Re: Calculated Dim

buzzy996 — Tue, 19 May 2015 12:58:35 GMT

try tis way,just remove ur both the dimension from dimensions tab and create one calculated dimension some thing like this with ur high/lower limits..

=if(Num((IRB_Lower_Band*100),0.000)>'0' and Num((IRB_Higher_Band*100),0.000)<'1','<1%',

if(Num((IRB_Lower_Band*100),0.000)>'1' and Num((IRB_Higher_Band*100),0.000)<'2','<2%','3%'))

Re: Calculated Dim

Clever_Anjos — Tue, 19 May 2015 13:40:34 GMT

Please check if this script fits your needs

LOAD Class(RecNo()/20,0.05, 'to') as Dim AutoGenerate 14;
LOAD dual('0.75 <= to < 1.35', 1.35) as Dim AutoGenerate 1;
LOAD dual('1.35 <= to < 2.5', 2.5) as Dim AutoGenerate 1;
LOAD dual('2.5 <= to < 5.5', 5.5) as Dim AutoGenerate 1;
LOAD dual('5.5 <= to < 10', 10) as Dim AutoGenerate 1;
LOAD dual('10 <= to < 20', 20) as Dim AutoGenerate 1;
LOAD dual('20 <= to < 100', 100) as Dim AutoGenerate 1;
LOAD dual('100 (default)', 101) as Dim AutoGenerate 1;