Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Autogenerate values based on intervals

Hi, Is there a way to find the max,min values for a calculated field in a chart table and split it to intervals into equal proportions?

eg my Interval is from -5 to 5, the interval would look like, -1 -2 -3 ...0...4 5.,

Any hel on this is appreciated, thanks in Advance

1 Reply
matt_crowther
Specialist
Specialist

Just thinking off the top of my head but you could try looking at using either the class() function or the valueloop() function as your dimension - look in the help file for details on both.

The valueloop() expression could be something along the lines of:

=valueloop(min(Value),max(Value),1)

That is unchecked.

Hope that helps,

Matt - Visual Analytics Ltd