QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Valued Contributor

Function Match()

Hello! I have I table like this

Sect     Com1   Com 2

1           4          23

2           3          2

5           1          32

6           10        13

4          67        45

3          34        23

But de Dimension Sect is Dimenssion Calculated Like this:

=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',

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

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

I know that in tab order you can use the function Match() like

=Match(Dimenssion,'Today','3',23','31')

But How can should be when the dimenssion is calculated?

Thanks