topic Re: Dual Replace Class Labels in QlikView

Dual Replace Class Labels

cbaqir — Thu, 03 Mar 2016 14:49:52 GMT

My current dimension is:

=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))

and it gives me these labels:

My customer wants the labels to display (and then sort the same way) more simply:

<60

60-120

>120

I've been playing with the Dual Replace function in the dimension but can't get it to work correctly.

Thanks.

Re: Dual Replace Class Labels

Gabriel — Thu, 03 Mar 2016 14:53:36 GMT

Hi,

Can you possibly attached sample file?

This help

Re: Dual Replace Class Labels

cbaqir — Thu, 03 Mar 2016 14:57:36 GMT

Added to original post.

Re: Dual Replace Class Labels

sunny_talwar — Thu, 03 Mar 2016 15:00:50 GMT

May be this:

=Dual(

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

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

Replace(Class(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION),REQUEST_ID), 60), '<= x <', '-'))),

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

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

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

Re: Dual Replace Class Labels

cbaqir — Thu, 03 Mar 2016 15:05:09 GMT

Perfect! Thanks, Sunny!

Re: Dual Replace Class Labels

MK_QSL — Thu, 03 Mar 2016 15:08:13 GMT

You can use below one also

=Aggr(

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

If(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION)>= 60 and Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION) <= 120, Dual('60-120',2),

If(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION)> 120, Dual('>120',3))))

,REQUEST_ID)

Re: Dual Replace Class Labels

cbaqir — Thu, 03 Mar 2016 15:23:16 GMT

So to apply the same logic to this version:

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

would it be something like this:

=Dual(
If(WORKFLOW_DURATION) < 60, '<60',
If(WORKFLOW_DURATION) > 120, '>120',
Replace(Class(WORKFLOW_DURATION)), 60), '<= x <', '-'),
If(WORKFLOW_DURATION) < 60, 0,
If(WORKFLOW_DURATION) > 120, 120,
Class(WORKFLOW_DURATION), 60)

Re: Dual Replace Class Labels

sunny_talwar — Thu, 03 Mar 2016 15:25:20 GMT

Some missing parenthesis:

=Dual(
If(WORKFLOW_DURATION) < 60, '<60',
If(WORKFLOW_DURATION) > 120, '>120',
Replace(Class(WORKFLOW_DURATION)), 60), '<= x <', '-'))),
If(WORKFLOW_DURATION) < 60, 0,
If(WORKFLOW_DURATION) > 120, 120,
Class(WORKFLOW_DURATION), 60))))

Re: Dual Replace Class Labels

cbaqir — Thu, 03 Mar 2016 15:26:08 GMT

That's giving me "Error in calculated dimension"

Re: Dual Replace Class Labels

sunny_talwar — Thu, 03 Mar 2016 15:27:50 GMT

And you had some extra parenthesis elsewhere:

=Dual(

If(WORKFLOW_DURATION < 60, '<60',

If(WORKFLOW_DURATION > 120, '>120',

Replace(Class(WORKFLOW_DURATION, 60), '<= x <', '-'))),

If(WORKFLOW_DURATION < 60, 0,

If(WORKFLOW_DURATION > 120, 120,

Class(WORKFLOW_DURATION, 60))))

Re: Dual Replace Class Labels

cbaqir — Thu, 03 Mar 2016 15:47:15 GMT

I was so close yet so far.