topic Re: last 12 months in QlikView

last 12 months

Thu, 07 Feb 2013 16:37:21 GMT

Hai Friends,

Please see The Attach File

Please Select Year and month Then Ii will show only one month

but i want if i select 2010 and month feb then chart will show last 12 months along with feb month

it means jan-2009 to feb 2010

so please Give Me Better Solution

Re: last 12 months

SunilChauhan — Thu, 07 Feb 2013 16:42:29 GMT

see the attached file

hope this helps you

Re: last 12 months

Thu, 07 Feb 2013 16:51:17 GMT

i did same as you sent

but they are asking like

if manuvally select year and month then chart will show last 12 month

any idea

Re: last 12 months

Thu, 07 Feb 2013 16:52:20 GMT

Try this expression

sum({1<FinalDate={">=$([12 rolling])<=$(MonthEnd)"}>} AmountTotal)

Re: last 12 months

Thu, 07 Feb 2013 17:24:04 GMT

hai Thanks,

but we have 8.2 set analysis not working pls send me solution with if analysis

Re: last 12 months

Thu, 07 Feb 2013 17:27:36 GMT

This would give the expression:

SUM( ALL IF( FinalDate >= [12 rolling] AND FinalDate <= MonthEnd, AmountTotal, 0 ) )

SUM( TOTAL IF( FinalDate >= [12 rolling] AND FinalDate <= MonthEnd, AmountTotal, 0 ) )

Re: last 12 months

Fri, 08 Feb 2013 15:57:39 GMT

Hi Ram,

try using the way luminary gave you.

Build a field:

Date(Date(Date#(MONTH&'-'&YEAR,'MMM-YY'),'DD-MM-YYYY'),'MMM-YY') as MonthYear

Then

use this expression:

Sum( if( MonthYear >= Date(addmonths(Max(MonthYear), -12), 'MMM-YY') and MonthYear<= Date(addmonths(Max(MonthYear), -1), 'MMM-YY')

AmountTotal

)

translated from luminary expr with set analysis.

And put as dimension of your chart MonthYear.

It should work ... I hope

Regards

Giampiero