# Third-Party Qlik Jobs

Contributor II

## how to calculate percentage between Q2-Q1 in qlikview

Hi All,

can someone help me i am not able to calculate the percentage Q2 Vs Q1.
please find the expression im using help,
kindly help me with your suggestions

Num(

Num(
Count( DISTINCT{<Period_IssueView={'Quarter'},[Issue Status Name_IssueView]={'Open'},[Issue Severity_IssueView]={'High'},_Ind_IssueView={'Y'},[As of Date_View]={">=\$(=vCurrentQuarterMaxDate) <=\$(=vYourMaxDate)"}>} [Issue ID_IssueView])

-
Count( DISTINCT{<Period_IssueView={'Quarter'},[Issue Status Name_IssueView]={'Open'},[Issue Severity_IssueView]={'High'},_Ind_IssueView={'Y'},[As of Date_View]={">=\$(vLast2Quarter) <=\$(=vCurrentQuarterMaxDate)"}>} [Issue ID_IssueView]))

/

Num(Count( DISTINCT{<Period_IssueView={'Quarter'},[Issue Status Name_IssueView]={'Open'},[Issue Severity_IssueView]={'High'},_Ind_IssueView={'Y'},[As of Date_View]={">=\$(vLast2Quarter)  <=\$(=vYourMaxDate)"}>} Total [Issue ID_IssueView]))

,'###%')

Navin P

7 Replies MVP

## Re: how to calculate percentage between Q2-Q1 in qlikview

Which object are you calculating this percentage in? Partner

## Re: how to calculate percentage between Q2-Q1 in qlikview

Hi Navin,

I think you are looking for %Growth of Q1 vs Q2

% Growth = (Current -Previous)/Previous

Contributor II

## Re: how to calculate percentage between Q2-Q1 in qlikview

using As of date im calculating the Percentage B/W Q2 vs Q1

Highlighted
Contributor II

## Re: how to calculate percentage between Q2-Q1 in qlikview

i tried with your logic, i got the wrong number please find the below image  Partner

## Re: how to calculate percentage between Q2-Q1 in qlikview

Hi Navin,
What is your expected value as per above record ?
and how did you got 900% for CIB
and 22% for CF growth where Q3 is 0 and Q4 is 2?

Thanks,
Ponkaviyarasu

Contributor II

## Re: how to calculate percentage between Q2-Q1 in qlikview

Q2 for CIB i have 9 issues,Q1 is 0, here i want to show 100%

But Q3 i have values for all LOBs now i want to allocate the 100% based on values,Please find the below expected result

 LOB Q1 Q2 Q2-Q1 Q3 Q3-Q2 AWM 0 0 0% 9 42.9% CF 0 0 0% 2 9.5% CIB 0 9 100% 10 47.6% ToTal 0 9 100% 21 100.0%

Many Thanks

Navin Partner

## Re: how to calculate percentage between Q2-Q1 in qlikview

Hi Navin,
From the above result, Total Allocation/(AWM+CF+CIB)

Q3:
100/(9+2+10);
100/21 = 4.76

Q3-Q2:
9*4.76 = 42.84 (42.9)
2*4.76 = 9.52 (9.5)
10*4.76=47.6
21*4.76 = 99.96 (100)
Community Browser