Discussion Board for collaboration related to QlikView App Development.
Is it possible to use the class() function to set an exponential scale, maybe by manipulating the class_width variable?
I have a bunch of responstimes of a calldesk. I want to count the number of calls which was responded to
a) between 0 and 15 minutes
b) between 15 and 60 minutes,
c) between 60 minutes and 4 hours,
d) between 4 and 8 hours,
e) more than 8 hours.
I don't want to set the intervals in the script, since this costs me too much flexibility in the dashboard.
Thanks a lot!!
Maybe I can aggregate?
With class by defalut you can use only equal scale (except some tricks for bounds and so on).
Try to make a formula that returns 1..N for your time values then use pick() to assign correspinding text labels.
Or you can program this logic with dozens of ifs.