topic Re: Comparative Analysis in QlikView

Comparative Analysis

Anonymous — Wed, 03 Feb 2016 08:39:00 GMT

I have the following expression in my comparative analysis:

Sum({[Group A] * $} Amount)

The above is a generalised expression used with a year dimension. I now need to convert this to be used with a month-year dimension to give a rolling 12 months figure with the following expression:

Sum({$<MonthDiff={"<12"}>} Amount)

How do I incorporate comparative analysis as per the first expression with this second expression?

Regards.

Re: Comparative Analysis

Anonymous — Wed, 03 Feb 2016 08:44:23 GMT

Hi,

Please see this post for an idea on how to do the above: Month on Month Comparison.

Re: Comparative Analysis

MK_QSL — Wed, 03 Feb 2016 08:53:06 GMT

What is the format of your MonthYear?

Re: Comparative Analysis

Anonymous — Wed, 03 Feb 2016 09:28:18 GMT

Hi Manish

it is as follows, from my calendar

Date(MonthStart(TempDate), 'MMM-YYYY') as MonthYear,

Regards.

Re: Comparative Analysis

MK_QSL — Wed, 03 Feb 2016 09:41:38 GMT

Try below

Calculating rolling n-period totals, averages or other aggregations

Re: Comparative Analysis

Anonymous — Wed, 03 Feb 2016 10:17:25 GMT

Manish

Many thanks, i have gone through this post. What i want is to incorporate 'Comparative Analysis' into the expressions

Re: Comparative Analysis

MK_QSL — Wed, 03 Feb 2016 10:19:03 GMT

Provide sample data or sample application to work..