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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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