topic Re: Months should come with previous months data in QlikView

Months should come with previous months data

prma7799 — Mon, 07 Dec 2015 10:53:32 GMT

Dear All,

1.I want current month with previous 23 months data total 24 bars should display without any selection

2.with selection

if suppose user select any financial year like 14-15 then it will show 24 bars but here only 21 bar present

and when i select financial year 13-14 then why 2015 data come .

PFA

Re: Months should come with previous months data

thakkarrahul01 — Mon, 07 Dec 2015 11:06:44 GMT

Hi,

your expression:

Sum({<Year=, Quarter=, FinancialYear, Year={'>=$(=Max(Year)-1) <=$(=Max(Year))'}>} Values)

If you remove "Year=, Quarter=, FinancialYear," :

Sum({<Year={'>=$(=Max(Year)-1) <=$(=Max(Year))'}>} Values)

It is working fine for me.

Regards,

Rahul

Re: Months should come with previous months data

swuehl — Mon, 07 Dec 2015 11:07:46 GMT

Change your dimension to MonthYear and make the set expression field modification on that field.

See attached.

Re: Months should come with previous months data

prma7799 — Mon, 07 Dec 2015 11:17:13 GMT

Hi Swuehl,

Thanks for Quick response.

Can you please tell me if I load data for month Oct-15 then nov-13 will come?

Thanks

Re: Months should come with previous months data

swuehl — Mon, 07 Dec 2015 11:24:40 GMT

Well, nov-13 is already there.

If you update your data including Oct-15, then Oct-15 bar will be added and the Oct-13 bar will be removed from the bar chart, that's how a rolling 24 month display works, right?

Re: Months should come with previous months data

prma7799 — Mon, 07 Dec 2015 11:31:55 GMT

Hi Swuehl,

When I am trying to achieve Growth line the chart is not coming properly...

Please help.

PFA

Re: Months should come with previous months data

swuehl — Mon, 07 Dec 2015 11:42:59 GMT

The calculation seems correct, if you want to show a year over year change.

If you are talking about the extension of the line to the far left, you can handle that with adding the set expression to your aggregations.

Re: Months should come with previous months data

prma7799 — Mon, 07 Dec 2015 11:53:01 GMT

Thanks Dear Sir.....