topic Re: Class() Data Issue in QlikView

Class() Data Issue

cbaqir — Thu, 04 Feb 2016 14:52:10 GMT

As you can see, it seems to be counting REQUEST_IDs that are not within the Business Days Turn Around Time indicated in the class.

For example, I would expect to see 16 REQUEST_IDs in Close Out for more than 120 days in the bottom table, but in reality there only appear to be 6.

How do I get both charts to reflect the correct counts?

Re: Class() Data Issue

swuehl — Thu, 04 Feb 2016 15:04:51 GMT

I think your two tables show different Business Days, second table uses set analysis which you need to include to first chart aggr() dimension to match

=Dual(If(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), '>120'),

If(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), 120))

edit:

Or alternatively adapt the second chart's expression to match count of the first chart, i.e. remove the set expression.

Re: Class() Data Issue

cbaqir — Thu, 04 Feb 2016 15:06:49 GMT

What would I do without you, Stefan? Thank you!

Re: Class() Data Issue

cbaqir — Tue, 09 Feb 2016 21:18:08 GMT

Follow up question for you... when I use this expression in a list box, selecting >120 makes the other options disappear. It worked fine with the old expression. Any idea how to overcome this?

Re: Class() Data Issue

sunny_talwar — Tue, 09 Feb 2016 21:20:47 GMT

Try this (Note the 1s in red)

=Dual(If(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), '>120'),

If(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), 120))

Re: Class() Data Issue

cbaqir — Tue, 09 Feb 2016 22:07:03 GMT

Thanks!

Re: Class() Data Issue

sunny_talwar — Tue, 09 Feb 2016 22:58:45 GMT

No problem

Re: Class() Data Issue

cbaqir — Thu, 11 Feb 2016 22:56:52 GMT

Ok, so here is the follow-up... we noticed that now the List Box value does not stay green if other list box filters are also selected.

It shows green when it's the only filter but if this and something else is selected, we get this:

Re: Class() Data Issue

cbaqir — Tue, 16 Feb 2016 22:19:46 GMT

Ok, so here are the questions of the day related to this change:

I am now looking at a Historical WorkFlow Step instead of the Current Workflow Step.

If I use this expression, the chart is adding the different step days together and producing a chart that is incorrect:

=Dual(If(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), '>120'),
If(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), 120))

What I would expect here is this view:

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

Not sure if it makes sense to use these two different expressions - but one for Current Workflow Step charts (previous in thread) and one for Historical view (this one).

Also, we noticed that now the List Box value does not stay green if other list box filters are also selected.

It shows green when it's the only filter but if this and something else is selected, we get this:

I believe it's not staying green because I am using the expression with the aggr and flag:

How can I get this expression list box to work in both scenarios for current and historical views?

Thanks!