Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

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

,'###%')

 

 Thanks in Advance
Navin P

7 Replies

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

Which object are you calculating this percentage in?

Highlighted
Partner
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

 

NavinReddy
Contributor II

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

Hi Sunny,Thanks for your reply 

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

NavinReddy
Contributor II

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

 Hi Pon kaviyarasu, Thanks for your reply

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

Untitled.png

Partner
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?

Can you explain your requirement,

Thanks,
Ponkaviyarasu

NavinReddy
Contributor II

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

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

LOBQ1Q2Q2-Q1Q3Q3-Q2
AWM 000%942.9%
CF000%29.5%
CIB09100%1047.6%
ToTal09100%21100.0%

Many Thanks

Navin

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