Percentage on date dimension

[FelipeG]

Hey Qlik Developers!

I have a table with this information:

Date	Name	Type	Amount
19/10/2020	name1	Type1	80
19/10/2020	name6	Type1	10
19/10/2020	name2	Type2	10
20/10/2020	name3	Type1	50
20/10/2020	name4	Type3	50
21/10/2020	name5	Type1	60

With this data I want to show a table chart with the percentage of amount for each type in a given date, like this:

Date	Type	Sum Amount	Percentage of day
19/10/2020	Type1	90	90%
19/10/2020	Type2	10	10%
20/10/2020	Type1	50	50%
20/10/2020	Type3	50	50%
21/10/2020	Type1	60	100%

How can I achieve this? I'm having trouble calculating the percentage and sum taking into account the date.

Kind Regards, 

Felipe.

[kaushiknsolanki]

Use this expression in your table.

Sum(Amount)/Sum(Total<Date> Amount)