How to create a measure/expression to calculate the % increase/decrease between 2 figures

[Anonymous]

Hello,

Please can you help with the following;

I need to calculate the % increase/decrease between 2 figures.

Example

Total jobs for FY16          10

Total jobs for FY17          15

Percentage increase is     50%

Thanks,

Kizzy

[stabben23]

(sum(Total jobs for FY17)-sum(Total jobs for FY16))/sum(Total jobs for FY16)

will gives you 0,5. You could use *100, but better to "show in percent (%)" in the number tab.

[Anonymous]

Hi Staffan,

Thanks for the quick reply.  I cannot get this expression to work.  Below is my actual expression to get to the fiscal totals.  I have matched them up to your expression (its split out here but in qlik its all one expression).  The colours are just for an easy visual.  Can you see what I am doing wrong?

Thanks,

Kizzy

(Sum(Total {$<[Requisition Status]={Closed},[Fiscal]={'FY17'}>}[Approve to Close])/Sum({$<[Requisition Status]={Closed},[Fiscal]={'FY17'}>}[Number of Reqs])

-sum(Total {$<[Requisition Status]={Closed},[Fiscal]={'FY16'}>}[Approve to Close])/Sum({$<[Requisition Status]={Closed},[Fiscal]={'FY16'}>}[Number of Reqs]))

/sum(Total {$<[Requisition Status]={Closed},[Fiscal]={'FY16'}>}[Approve to Close])/Sum({$<[Requisition Status]={Closed},[Fiscal]={'FY16'}>}[Number of Reqs])

(sum(Total jobs for FY17)

-sum(Total jobs for FY16))

/sum(Total jobs for FY16)

[sunny_talwar]

Is to goal to show this in a text box object?

[stabben23]

Hmm, i'll think it all about parentheses,

add first (yellow) Expression as it is, does it shows correct info, then add the second (blue) still as expected, then add the green part and see whats happens, if not, adjust parentheses to get correct value.

[stabben23]

Relevant question, = sign missing.

[Anonymous]

Hi Staffan,

Where is the = missing from?

Thanks,

Kizzy

[Anonymous]

No, it should be in a bar chart of pivot table using a dimension.

Thanks,

Kizzy

[Anonymous]

All the parentheses individually work and provide a total figure

[stabben23]

ok, but still wrong/no value?

= was missing if you should show in text Box.