topic Re: Range for amount in QlikView

Range for amount

Mon, 15 Dec 2014 17:41:14 GMT

In one of my table it has Depreciation amount and ID and 20fields how to make range of data. In this table more than 150 ID need range 0-10,10-20,20-30.

ID, Dep Amount

1	9658
2	9856
3	9845
4	9874
5	9854
6	9852
7	9632
8	9541
9	9745
10	3698

Thanks

Re: Range for amount

its_anandrjs — Mon, 15 Dec 2014 17:43:17 GMT

Hi,

You have to create the calculated dimension and use the Class function in and straight chart or pivot chart

=Class(ID,10)

Regards

Anand

Re: Range for amount

Mon, 15 Dec 2014 18:10:23 GMT

But it give symbols in the axis with range '<= x <' any reasons why.

Jay

Re: Range for amount

maxgro — Mon, 15 Dec 2014 19:58:31 GMT

maybe with replace, ( '<= x <' is the default)

=replace(class(ID, 10), '<= x <', '-')

Re: Range for amount

its_anandrjs — Mon, 15 Dec 2014 20:22:52 GMT

Hi,

You have to replace the values of the '<= x <' because it is generated by Class function.

=Replace(Class(ID,10),'<= x <', '-')

Regards

Anand

Re: Range for amount

MarcoWedel — Mon, 15 Dec 2014 22:57:49 GMT

Hi,

one suggestion. To avoid sorting issues generate a dual value after replacing '<= x <' with '-':

=Dual(Replace(Class(ID,10),'<= x <', '-'),Class(ID,10))

hope this helps

regards

Marco

Re: Range for amount

Tue, 16 Dec 2014 18:44:17 GMT

Thanks i manage this and thanks all for good suggestions.

Jay