Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.