how to calculate percentage between Q2-Q1 in qlikview

[NavinReddy]

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]))

,'###%')

 Thanks in Advance
Navin P

[sunny_talwar]

Which object are you calculating this percentage in?

[Ponkaviyarasu]

Hi Navin,

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

% Growth = (Current -Previous)/Previous

[NavinReddy]

Hi Sunny,Thanks for your reply 

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

[NavinReddy]

 Hi Pon kaviyarasu, Thanks for your reply

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

[Ponkaviyarasu]

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?

Can you explain your requirement,

Thanks,
Ponkaviyarasu

[NavinReddy]

Sorry for my late reply

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

[Ponkaviyarasu]

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)