Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
olguita2014
Creator
Creator

Advanced data grouping

Hi,

I hope your help!!!...

I want to select a date, and then calculate sum(Cantidad_Saldo), if (sum(Cantidad_Saldo)<>0, Only show  records of the last date, nothing to show).... 

Untitled.png

Labels (2)
2 Replies
pradosh_thakur
Master II
Master II

If you could add some sample input and how your output should look like , it will be easier to help . Please elaborate a bit as your question is bit unclear.

Learning never stops.
olguita2014
Creator
Creator
Author

  • I have this data:
DateKARHORAMVESUFIJOVEHCHASISCantidad_Saldo
5/4/2018 00:0012:26:15AAJTMZF9EV1ED0220401
31/7/2018 00:0016:07:08AAJTMZF9EV1ED022040-1
31/7/2018 00:0021:47:49AAJTMZF9EV1ED0220401
4/2/2019 00:0016:49:15AAJTMZF9EV1ED022040-1
  • I want to select a date, and it depends on that to make a calculation, example: 31/7/2018

 

  • If I select the date 31/7/2018 then the result of the field Cantidad_Saldo must be the total sum of all the amounts less than or equal to the chosen date. Result: Sum(Cantidad_Saldo)=1.

 

 

  • If the result of Sum(Cantidad_Saldo)=1, then create new field with the following data: Con Saldo, if not the following data is: Sin Saldo.

 

Date

KARHORA

MVESUFIJO

VEHCHASIS

Sum(Cantidad_Saldo)

Estado_Saldo

31/7/2018 00:00

21:47:49

AA

JTMZF9EV1ED022040

1

Con Saldo

5/4/2018

12:26:15

AA

JTMZF9EV1ED022040

1

Con Saldo

4/2/2019

16:49

AA

JTMZF9EV1ED022040

0

Sin Saldo