topic Re: 13 month chart in dimension in QlikView

13 month chart in dimension

rcorcoran — Tue, 06 Jan 2015 13:26:19 GMT

Hi I have a chart in the document attached. I want it to show the max month loaded and 12 other months data also.

Any help would be appreciated.

Rhona

now second example attached Scorecard Acute - dnd which has data for both years

Re: 13 month chart in dimension

Anonymous — Wed, 07 Jan 2015 09:05:35 GMT

Hi rhona,

so, regarding your test data, do you want to show Nov 14 (if 2014 is selected), Oct 14, Sept 14... till Nov 13?

Thanks.

Re: 13 month chart in dimension

rcorcoran — Wed, 07 Jan 2015 09:10:04 GMT

Yes Elena

I want the chart to show the Max month loaded with data and the previous 12 months as well. showing 13 months in total. so if the last month loaded was nov 14 then it should show till Nov 13.

Thanks

Re: 13 month chart in dimension

Anonymous — Wed, 07 Jan 2015 09:18:36 GMT

It's quite diffucult making some tests because there aren't data from Jun to Nov: can you upload complete data?

Re: 13 month chart in dimension

rcorcoran — Wed, 07 Jan 2015 09:37:04 GMT

Hi Elena

I have now attached another file with an example that has data for 2 years

Thanks

Re: 13 month chart in dimension

rubenmarin — Wed, 07 Jan 2015 10:30:04 GMT

Hi Rhona, you can do this with set analysis, ie for the first expression (Dublin East...) it can be:

=Sum({$<[SA8 No waiting > 13 wks colon] ={11},HospitalGroup_SPKey={5007},ReferredYYYY, YearMonth={">=$(=AddMonths(Max(YearMonth), -12))<=$(=Max(YearMonth))"}>}ActualValue)

Re: 13 month chart in dimension

rcorcoran — Wed, 07 Jan 2015 10:36:32 GMT

Thanks Ruben that seems to work fine.

It is a great help

Rhona