topic Re: Function Match() in QlikView

Function Match()

pgalvezt — Wed, 18 Jul 2012 16:33:51 GMT

Hello, I have a table created like this:

Sect Com1 Com2

Today 23 45

61-80 Days 12 45

3-5 Days 13 23

Sect is dimenssion Calculated like:

=if(aggr(sum(date(vDate)-Field1),Field2)= vDate, 'Today',

if(aggr(sum(date(vDate)-Field1),Field2)>=1 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=30, '3 - 5 Days',

if(aggr(sum(date(vDate)-Field1),Field2)>=31 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=60, 23-45 Days,

if(aggr(sum(date(vDate)-Field1),Field2)>=61 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=90, '61-90 Días'))))

I know the fuction Match() I can sorter like

Today

3-5 Days

61-80 Days

But How can should be when is dimenssion calculated?

Thank You!

pgalvezt — Wed, 18 Jul 2012 16:57:32 GMT

Any Help?

Thank You

pgalvezt — Wed, 18 Jul 2012 17:11:09 GMT

Any Help?

Thank You

swuehl — Wed, 18 Jul 2012 17:34:06 GMT

You can create duals in your calculated dimension and then just sort by number:

=if(aggr(sum(date(vDate)-Field1),Field2)= vDate, dual('Today',1) ,

if(aggr(sum(date(vDate)-Field1),Field2)>=1 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=30, dual('3 - 5 Days',2),

if(aggr(sum(date(vDate)-Field1),Field2)>=31 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=60,dual(' 23-45 Days',3),

if(aggr(sum(date(vDate)-Field1),Field2)>=61 And aggr(sum(date(vDate)-TD_Mora),Num_Tarjeta)<=90, dual('61-90 Días',4)))))

Regards,

Stefan

P.S: This is a forum mostly run by volunteers, so you shouldn't expect an answer within minutes...

pgalvezt — Wed, 18 Jul 2012 18:03:29 GMT

Perfect!!

Thanks