topic Re: compare selected Quarter with previous Quarter in QlikView

compare selected Quarter with previous Quarter

Thu, 28 Jun 2012 12:10:59 GMT

Hi,

I want to compare Selected Quarter with Previous Quarter using Set Analysis. Can any1 help me with this?

- Yojas

Re: compare selected Quarter with previous Quarter

deepakk — Thu, 28 Jun 2012 12:49:23 GMT

hi Yojas,

I used one of the method of calculating previous qtr. I hope the attach application helps you out.

Deepak

Re: compare selected Quarter with previous Quarter

Fri, 29 Jun 2012 06:38:36 GMT

Thanx.....

-Yojas

Re: compare selected Quarter with previous Quarter

Fri, 14 Jun 2013 05:29:43 GMT

Really efficient way to do this calculation. If you have strings in your Qtr field, simply use this slight code change from the App -

Sum({<FiscalQuarter={$(=Maxstring(FiscalQuarter))}>}Sales)

Re: compare selected Quarter with previous Quarter

Wed, 11 Sep 2013 16:01:10 GMT

Wanted to add to the post and thank Deepak, who ended my full-day search through the community for the solution to a similar problem. As mine was a bit more complex - I could not work with a Year Dimension in my Pivot Chart and had to get the "Year" information into the Quarter selection. I adapted the variable approach like this:

1. Created a List box based on my dates but used an expression to condense to Quarters, so to a user it would appear as a single-selection, whereas all days of the quarter are selected. =Year(Date)&'_Q'&ceil(month(Date)/3)

2. Defined a variable vYQ-1 based on the current date selection, calculated one quarter back (minus 92 days) and used Year Function: =Year(date(max(Date)-92,'DD.MM.YYYY'))

3. Defined a variable vQ-1 based on the current date selection, calculated one quarter back (minus 92 days) and used the function to get: =ceil(month(date(max(Date)-92,'DD.MM.YYYY'))/3)

4. Used Set Analysis in the chart to get the "Previous Quarter" from the current selection =Sum({1<Year={$(vYQ-1)},_Qtr={$(vQ-1)} >} Amount)

Re: compare selected Quarter with previous Quarter

nevets22 — Thu, 24 Aug 2017 20:02:16 GMT

Thanks for sharing! This helped me tremendously!