topic Re: Class Function with Max Interval? in QlikView

Class Function with Max Interval?

cbaqir — Thu, 21 Jan 2016 15:47:24 GMT

I am using a class function that shows =class(WORKFLOW_DURATION,30,WORKFLOW_DURATION) .

I want the largest interval to show >120. Rather than 120 - 150, etc... How can I do this?

Thanks,

Cassandra

Re: Class Function with Max Interval?

sunny_talwar — Thu, 21 Jan 2016 15:49:23 GMT

May be this:

=If(WORKFLOW_DURATION <= 120, Class(WORKFLOW_DURATION, 30, WORKFLOW_DURATION), '>120')

Re: Class Function with Max Interval?

cbaqir — Thu, 21 Jan 2016 15:53:33 GMT

Thanks, Sunny. Then how would I sort it so that >120 comes after the other intervals?

Re: Class Function with Max Interval?

sunny_talwar — Thu, 21 Jan 2016 15:57:06 GMT

Try this:

Dual(If(WORKFLOW_DURATION <= 120, Class(WORKFLOW_DURATION, 30, WORKFLOW_DURATION), '>120'), Class(WORKFLOW_DURATION, 30, WORKFLOW_DURATION))

Re: Class Function with Max Interval?

cbaqir — Thu, 21 Jan 2016 16:06:36 GMT

That doesn't look quite right...

Re: Class Function with Max Interval?

sunny_talwar — Thu, 21 Jan 2016 16:10:02 GMT

Oh I understand why it is doing this:

May be try this:

Dual(

If(WORKFLOW_DURATION <= 120, Class(WORKFLOW_DURATION, 30, WORKFLOW_DURATION), '>120'), If(WORKFLOW_DURATION <= 120, Class(WORKFLOW_DURATION, 30, WORKFLOW_DURATION), 150)

)

Re: Class Function with Max Interval?

cbaqir — Thu, 21 Jan 2016 16:12:20 GMT

Thanks, Sunny!

Re: Class Function with Max Interval?

cbaqir — Thu, 21 Jan 2016 19:37:15 GMT

Any idea why the interval shows 3 numbers? What does the middle number mean - an average or something?

Re: Class Function with Max Interval?

sunny_talwar — Thu, 21 Jan 2016 19:46:12 GMT

I think you have specified the x to be replaced by WORKFLOW_DURATION

Class(WORKFLOW_DURATION, 30, WORKFLOW_DURATION), '>120')

Change the third argument to make it something static (QlikView ‒ class - script and chart function)

Re: Class Function with Max Interval?

cbaqir — Thu, 21 Jan 2016 22:23:39 GMT

For some reason, I am getting the same REQUEST_ID counted multiple times and not sure why. I would only expect it to be counted once in 60-90 since the duration is 70 days. Any idea? I am thinking I need to use something like this: =class(Sum(total WORKFLOW_DURATION),30)

Dimensions:

dPgmPm (a group)
=Dual( If(WORKFLOW_DURATION <= 120, Class(WORKFLOW_DURATION, 30), '>120'), If(WORKFLOW_DURATION <= 120, Class(WORKFLOW_DURATION, 30), 120) )
=if(match(CUR_WORKFLOW_STEP_NAME,'Project Initiation and Design', 'Project Quality Review', 'Planning', 'Implementation', 'Close Out')>0,CUR_WORKFLOW_STEP_NAME,null())

Expression: count(DISTINCT REQUEST_ID)

Re: Class Function with Max Interval?

sunny_talwar — Thu, 21 Jan 2016 22:58:31 GMT

Can you share a sample?

Re: Class Function with Max Interval?

sunny_talwar — Fri, 22 Jan 2016 15:46:07 GMT

I am seeing just one bar for the selection you have in your application.

Re: Class Function with Max Interval?

cbaqir — Fri, 22 Jan 2016 20:04:32 GMT

If you Clear the selections, however, now the intervals don't look right.

If you look at the expression I am using, it is now Dual(If(WORKFLOW_DURATION <= 120, Class(Sum(total WORKFLOW_DURATION), 60), '>120'),
If(WORKFLOW_DURATION <= 120, Class(Sum(total WORKFLOW_DURATION), 60), 120))

Re: Class Function with Max Interval?

Fri, 22 Jan 2016 21:20:16 GMT

Create the Buckets in the script with IntervalMatch function.

Re: Class Function with Max Interval?

cbaqir — Fri, 22 Jan 2016 23:10:21 GMT

Do you have a reference for that?

Re: Class Function with Max Interval?

cbaqir — Mon, 25 Jan 2016 18:05:39 GMT

Please see updated sample.

Re: Class Function with Max Interval?

sunny_talwar — Mon, 25 Jan 2016 18:09:48 GMT

Can you point out what isn't working? May be tell us what selections to make and what are the expected result based on those selections

Re: Class Function with Max Interval?

cbaqir — Mon, 25 Jan 2016 18:16:10 GMT

if you select REQUEST_ID 182921, you will see two versions of the chart. The top one shows two buckets for one request (not sure why). The second chart looks correct with the 60-120 bucket compared to the data on the bottom showing 101 business days.

However, if you clear the selections, you will see the buckets for the second chart no longer reflect 0-60, 60-120 and >120. This is why I was playing with the Class(Sum(total))) in the expression...

Does that help? Sorry for the confusion.

Re: Class Function with Max Interval?

sunny_talwar — Mon, 25 Jan 2016 19:35:23 GMT

Based on the REQUEST_ID selection, there are two rows of data one is between 0 and 60 and other is between 60 and 120. That is why you see two bars. Would you want to add them together when you create classes?

Re: Class Function with Max Interval?

sunny_talwar — Mon, 25 Jan 2016 19:38:26 GMT

See if this is what you want?