Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

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

0 Replies