Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sumar Fecha

Tengo

Fecha         Deuda

201701           5

201702           10

201703           25

201704           30

201705            2

Quiero seleccionar 201701 y 201702 y que en dos cuadros me muestre:

La suma de 201701 y 201703

La suma de 201702

La suma de 201705

Gracias

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Não tenho certeza, qual é a lógica por trás, talvez isso?

If(Match(Fecha, '201701', '201702'), Sum({<Fecha = {'201701', '201702'}>} Deuda),

If(Match(Fecha, '201702'), Sum({<Fecha = {'201702'}>} Deuda),

If(Match(Fecha, '201705'), Sum({<Fecha = {'201705'}>} Deuda))))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni

Não tenho certeza, qual é a lógica por trás, talvez isso?

If(Match(Fecha, '201701', '201702'), Sum({<Fecha = {'201701', '201702'}>} Deuda),

If(Match(Fecha, '201702'), Sum({<Fecha = {'201702'}>} Deuda),

If(Match(Fecha, '201705'), Sum({<Fecha = {'201705'}>} Deuda))))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

sim, eu acho que vc e um mestre kkkkkkkkkk, muito brigado ate mais