Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a table as shown in the screenshot below :
I'm trying to sum the quantity of a specific date ( 01/02/2021) to all the other field, i tried the following but i didn't get the results I'm looking for
Can you guys help me, i just need the results either in the script or in the front end.
Thank you so much,
I found a solution, I should've just sum the total aggregated the data for 01/02/2021 (aggregated by Family):
sum( Quantity ) + sum( {< Date={'01/02/2021'} >} Total <Family> Quantity )
I think the function you are looking for is:
Sum(total <Date> Quantity)
Cheers,
Oleg
Thank you for your reply, however that's not exactly what i'm looking for the expression Sum(total <Date> Quantity) will show the sum of all quantity of a date disregarding the family, what i really want is a way to save the quantity of an exact date (01/02/2021) of each family and add it to the other rows depending on which family they belong to.
In the qlikview that i shared the values i'm looking to use are 30(family A) and 35(family B)
Sum(total {<Date ={'01/02/2021'} >} Quantity) will result 65
The final result I'm looking for is adding the sum(quantity) where the date is 01/02/2021 and family A to all the other rows where the family is A. and same thing for Family B.
Thank you so much for your help.
I found a solution, I should've just sum the total aggregated the data for 01/02/2021 (aggregated by Family):
sum( Quantity ) + sum( {< Date={'01/02/2021'} >} Total <Family> Quantity )