Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

HOW TO CALCULATE DELTA (%) BETWEEN TWO MEASURE

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

3 Replies
Highlighted
Specialist
Specialist

Hello!

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

Highlighted
Contributor III
Contributor III

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

Highlighted
Specialist
Specialist

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:

delta_in_perc.png

what should be done in another way?