Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exponential scale with class()-function?

Hello everybody,

Is it possible to use the class() function to set an exponential scale, maybe by manipulating the class_width variable?

Fi.

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.

Any suggestions?

Thanks a lot!!

2 Replies
Not applicable
Author

Maybe I can aggregate?

whiteline
Master II
Master II

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.