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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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