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: 
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 (1)
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