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: 
yanivvl0
Creator III
Creator III

How to sum sub level by dates ?

hi to all ,

i have projects , and in a project can be some books , each book has amount of unitss , and each project make savings of units.

i need to sum for a save-date of project the saved units until the save-date , and also the book-units that have any step until the save-date. 

for example in this project for save-date 1/1/2016 there is 2 saved units , but no book units bcause any of the tree books has a step beffore 1/1/2016 .

for example in this project for save-date 1/6/2016 there is 15 saved units , and 104 book units bcause all of the tree books has a step beffore 1/6/2016 .

project books steps save.PNG

i need to see project - save-date - saved units - book units  .

THANKS !

15 Replies
yanivvl0
Creator III
Creator III
Author

HI Sunny , again I highly appreciate the professional help you give !!

sunny_talwar

No problem my friend...

yanivvl0
Creator III
Creator III
Author

HI Sunny , i found a little err in sum (save units) , at the yellow marks the aggrigation Resetting :exmple prjbook_dates_sums 3.PNG

sunny_talwar

I am not seeing this

Capture.PNG

yanivvl0
Creator III
Creator III
Author

my mistake ,,

sunny_talwar

What was wrong?