topic Re: Exponential scale with class()-function? in QlikView https://community.qlik.com/t5/QlikView/Exponential-scale-with-class-function/m-p/379238#M141416 <HTML><HEAD></HEAD><BODY><P>With class by defalut you can use only equal scale (except some tricks for bounds and so on).</P><P>Try to make a formula that returns 1..N for your time values then use pick() to assign correspinding text labels.</P><P>Or you can program this logic with dozens of ifs.</P></BODY></HTML> Mon, 03 Sep 2012 12:50:13 GMT whiteline 2012-09-03T12:50:13Z Exponential scale with class()-function? https://community.qlik.com/t5/QlikView/Exponential-scale-with-class-function/m-p/379236#M141414 <HTML><HEAD></HEAD><BODY><P>Hello everybody, </P><P></P><P>Is it possible to use the class() function to set an exponential scale, maybe by manipulating the class_width variable?</P><P></P><P>Fi. </P><P></P><P>I have a bunch of responstimes of a calldesk. I want to count the number of calls which was responded to</P><P></P><P>a) between 0 and 15 minutes</P><P>b) between 15 and 60 minutes, </P><P>c) between 60 minutes and 4 hours, </P><P>d) between 4 and 8 hours, </P><P>e) more than 8 hours. </P><P></P><P>I don't want to set the intervals in the script, since this costs me too much flexibility in the dashboard. </P><P></P><P>Any suggestions?</P><P></P><P>Thanks a lot!!</P></BODY></HTML> Mon, 20 Aug 2012 15:20:13 GMT https://community.qlik.com/t5/QlikView/Exponential-scale-with-class-function/m-p/379236#M141414 2012-08-20T15:20:13Z Re: Exponential scale with class()-function? https://community.qlik.com/t5/QlikView/Exponential-scale-with-class-function/m-p/379237#M141415 <HTML><HEAD></HEAD><BODY><P>Maybe I can aggregate?</P></BODY></HTML> Tue, 21 Aug 2012 14:27:45 GMT https://community.qlik.com/t5/QlikView/Exponential-scale-with-class-function/m-p/379237#M141415 2012-08-21T14:27:45Z Re: Exponential scale with class()-function? https://community.qlik.com/t5/QlikView/Exponential-scale-with-class-function/m-p/379238#M141416 <HTML><HEAD></HEAD><BODY><P>With class by defalut you can use only equal scale (except some tricks for bounds and so on).</P><P>Try to make a formula that returns 1..N for your time values then use pick() to assign correspinding text labels.</P><P>Or you can program this logic with dozens of ifs.</P></BODY></HTML> Mon, 03 Sep 2012 12:50:13 GMT https://community.qlik.com/t5/QlikView/Exponential-scale-with-class-function/m-p/379238#M141416 whiteline 2012-09-03T12:50:13Z