HOW TO CALCULATE DELTA (%) BETWEEN TWO MEASURE

[gabroteddy]

Hi,

I have this problem.

I extract value in a qlik's table (see the attached ex.xlsx)...notw i want calculate in a separate table:

1. The SUM of all QTA VALUE for each month
2. The delta (in %) of this SUM between a specific month FIXED (example GIU) and the other month

Can soomeone help me?

Thx

[Sergey_Shuklin]

Hello!

Please see the attachement. Is this type of delta calculating suitable for you?

[gabroteddy]

Hi Sergey,

thx for the answer.

Your solution doesn't' work for the point 2.

1. The SUM of all QTA VALUE for each month
2. The delta (in %) of this SUM between a specific month FIXED (example GIU) and the other month

The expression

$(=sum({<[Mese Esame] = p([Mese Esame])>}Qta))

/

sum({<[Mese Esame] = e([Mese Esame])>}Qta)

-1

Not give me the aspected output.

Is possibile to have another example?

Thx

[Sergey_Shuklin]

Hello!

So, the reasonable question will be: what is the expected output?

Beacuse, I'm fixin a gui and see the delta with other month:

what should be done in another way?