topic Re: adding a specific value to a straight table in QlikView

adding a specific value to a straight table

WalidChoukri — Tue, 02 Mar 2021 10:41:26 GMT

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,

Re: adding a specific value to a straight table

Oleg_Troyansky — Tue, 02 Mar 2021 13:02:03 GMT

I think the function you are looking for is:

Sum(total <Date> Quantity)

Cheers,

Oleg

Re: adding a specific value to a straight table

WalidChoukri — Tue, 02 Mar 2021 13:49:05 GMT

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.

Re: adding a specific value to a straight table

WalidChoukri — Thu, 18 Mar 2021 08:46:12 GMT

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 )