Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor

Autogenerate values based on intervals

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

Community Browser