Calculated Dim

[priyarane]

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

[buzzy996]

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

[crusader_]

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

[priyarane]

Hi Shiva,

PFA

[ToniKautto]

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

How to use Class() function

[priyarane]

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

[ToniKautto]

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.

[buzzy996]

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%'))

[Clever_Anjos]

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;