Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
pgalvezt
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

Community Browser