Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating Bands - Class or not??

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

1 Solution

Accepted Solutions
Nicole-Smith

I think you may want something like:

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

which returns:

Sample file is also attached.

View solution in original post

7 Replies
jvishnuram
Partner - Creator III
Partner - Creator III

Hi Zama,

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

jagannalla
Partner - Specialist III
Partner - Specialist III

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
MVP
MVP

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

104873.jpg

Not applicable
Author

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

I think you may want something like:

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

which returns:

Sample file is also attached.

Not applicable
Author

Thank you Nicole

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

Not applicable
Author

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