topic Re: Line chart showing 12month rolling values in QlikView

Line chart showing 12month rolling values

Mon, 04 Jan 2016 12:18:43 GMT

Hi there ,

this is my expression :

if(OMetric= 'Gross Margin', sum({<FY={$(vMaxYear_CompletePeriod)},Flag={'Actual'},[Headline_Fig]={'Gross Margin'}>}Amt)/1000,

I want the line chart to show the values for 12 months... say if i click on 2016 , period 6, it should show from 2015 period 7 to 2016 period 6...

Could anyone help me with the same please ?

Thanks much

Re: Line chart showing 12month rolling values

sunny_talwar — Mon, 04 Jan 2016 12:51:11 GMT

Is you FY runs from beginning of period 7 to end of period 6? If it does than your FY={$(vMaxYear_CompletePeriod)} should already be taking care of what you need? What exactly isn't working? Can you provide more details?

Re: Line chart showing 12month rolling values

Chanty4u — Mon, 04 Jan 2016 12:52:49 GMT

hi,

Set Analysis for Rolling Periods

chk dis

Re: Line chart showing 12month rolling values

HirisH_V7 — Mon, 04 Jan 2016 12:56:43 GMT

Hi ,

Your line chart expression should be,

=sum({1< Date = {">=$(=MonthStart(Max(Date), -11))<=$(=MonthEnd(Max(Date)))"}>}Sales)

HTH,

Hirish

Re: Line chart showing 12month rolling values

koushik_btech20 — Mon, 04 Jan 2016 13:08:00 GMT

Hi vidisha,

You can create date using period and Year,

Like for Period 6 and Year 2015,

makedate(Year,Period) as Date //-so the date will be like 01/06/2015

Then in the expression just mention start date and end date inside set expression using variable as date range like,

=sum({Date={'>=$(vStartDate)<=$(vEnddate)'}}Sales)

vStartdate=Addyears(vEndDate,-1)

vEnddate=Max(Date)

Regards,

Koushik

Re: Line chart showing 12month rolling values

Mon, 04 Jan 2016 14:08:47 GMT

Hey Sunny,

when i click on 2015, it shows values for all 12 months.. when i click 2016, i want it to shows values for 2016- period 1 to period 6...

On click of 2016, i want to show the period from 2015th period 7 to 2016th period 6 (thats 12 month in total)

Thanks much

Re: Line chart showing 12month rolling values

Mon, 04 Jan 2016 14:10:40 GMT

I have already checked that.. thanks much