topic Creating Bands - Class or not?? in QlikView

Creating Bands - Class or not??

Tue, 21 Jan 2014 14:16:23 GMT

Hello guys,

I need help with creating 800 bands between 344 and 557066.

I want to split them into 800 equal groups to use in a bar chart.

Any suggestions

jvishnuram — Tue, 21 Jan 2014 14:20:06 GMT

Hi Zama,

You Can use tha interval() Function and if any doubt about it go to help.

jagannalla — Tue, 21 Jan 2014 14:20:45 GMT

Hi,

Please refer this link Range as a dimension, it is near to your requirement. If not please explain little bit more on your requirement.

Cheers!!!

Jagan

maxgro — Tue, 21 Jan 2014 19:59:39 GMT

like this? calculated dimension is =class(value, round((557066-344)/800), 'x', 344)

Wed, 22 Jan 2014 07:42:05 GMT

It seems I am gonna have to use the 'IF' statement because the result should be something of the following:

y axis: 696, 1329, 2088, 2784, ....................73766, 74462

And this is derived from (557066 - 344)/800

=696

therefore 696,

696 + 696 = 1329,

1329 +696 = 2088,

2088 + 696 = 2784........etc.

this goes on 800 times.

How do I get this as a dimension?

Nicole-Smith — Wed, 22 Jan 2014 15:39:28 GMT

I think you may want something like:

=Class(Value,696,'x',0)

which returns:

Sample file is also attached.

Thu, 23 Jan 2014 09:00:33 GMT

Thank you Nicole

Your solution worked. All I had to do was apply the num function to the formula and it worked.

Thu, 23 Jan 2014 14:13:56 GMT

Hi Massimo

Can you tell me how you got to the 'Value' you are using in this dimension?

=class(value, round((557066-344)/800), 'x', 344)

Zama