topic Autogenerate values based on intervals in QlikView https://community.qlik.com/t5/QlikView/Autogenerate-values-based-on-intervals/m-p/315693#M587338 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>eg my Interval is from -5 to 5, the interval would look like, -1 -2 -3 ...0...4 5.,</P><P></P><P>Any hel on this is appreciated, thanks in Advance</P></BODY></HTML> Fri, 20 May 2011 08:59:05 GMT 2011-05-20T08:59:05Z Autogenerate values based on intervals https://community.qlik.com/t5/QlikView/Autogenerate-values-based-on-intervals/m-p/315693#M587338 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>eg my Interval is from -5 to 5, the interval would look like, -1 -2 -3 ...0...4 5.,</P><P></P><P>Any hel on this is appreciated, thanks in Advance</P></BODY></HTML> Fri, 20 May 2011 08:59:05 GMT https://community.qlik.com/t5/QlikView/Autogenerate-values-based-on-intervals/m-p/315693#M587338 2011-05-20T08:59:05Z Autogenerate values based on intervals https://community.qlik.com/t5/QlikView/Autogenerate-values-based-on-intervals/m-p/315694#M587339 <HTML><HEAD></HEAD><BODY><P> 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.</P><P></P><P>The valueloop() expression could be something along the lines of: </P><P></P><P>=valueloop(min(Value),max(Value),1)</P><P></P><P>That is unchecked.</P><P></P><P>Hope that helps,</P><P></P><P>Matt - Visual Analytics Ltd</P></BODY></HTML> Fri, 20 May 2011 11:36:41 GMT https://community.qlik.com/t5/QlikView/Autogenerate-values-based-on-intervals/m-p/315694#M587339 matt_crowther 2011-05-20T11:36:41Z