Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ecabanas
Contributor II

how to calculate total of month

Hi,

I'm making a table to calculate the % of sales of each product comparing for the total units sold by the category.

I'm using the following formula to calculate the number of units sold in the month

=Sum (TOTAL(unit_quantity * quantity_delivered))

But as shown in the picture,  the amount is the addition of the 2 months selected

2019-05-09_12h37_34.png

Any idea of how to show the total amount for each month?

 

Thanks'

1 Reply

Re: how to calculate total of month

Try this

=Sum(TOTAL <Month> unit_quantity * quantity_delivered)