Qlik Community

Qlik Sense App Development

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

Contributor II

how to calculate total of month


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


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



1 Reply

Re: how to calculate total of month

Try this

=Sum(TOTAL <Month> unit_quantity * quantity_delivered)