topic Re: Quarter on Quarter Analysis in QlikView

Quarter on Quarter Analysis

Thu, 20 Feb 2014 03:55:21 GMT

Hi All,

I want an expression for quarter or quarter. Chart should look like below Image.

Expression : premium\turnover

Dimension : Quarter

If the premium\turnover of Q2 is greater than Q1 then Red Arrow, If the premium\turnover of Q3 is greater than Q2 then Red Arrow.

If premium\turnover of Q4=Q3 then Amber Arrow. For Q1 i have to compare with previous years Q4.

Please send me the expression or QVW.

Please send ASAP

Thanks & Regards,

Keerthi

Re: Quarter on Quarter Analysis

vikasmahajan — Thu, 20 Feb 2014 05:53:44 GMT

Following Expression for Prev Yr Qtr

SUM({$<FinancialYear=,MonthName=,Quarter=

,[Posting Date]={">=$(=QuarterStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-1))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-3))"}

>}[Sales Amount])

Following Expression for Curr Yr Qtr

SUM({$<FinancialYear=,Quarter=,MonthName=

,[Posting Date]={">=$(=QuarterStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Sales Amount])

Base on this calculate Growth % and show arrows using png with this post Re: Red or green arrow image based on values

Hope this help you

Vikas

Re: Quarter on Quarter Analysis

Thu, 20 Feb 2014 05:59:49 GMT

Please explain me how do i use it in my expression ??