topic Re: Re: Re: forecasting in qlikview in QlikView

forecasting in qlikview

Sun, 24 Aug 2014 14:02:29 GMT

Hi Experts,

i have the data like this year,quarter and sales.if user select quarter i want to show current year quarter(i.e,Q3 of 2014) and next qaurter of the year(i.e,Q4 of 2014) and if user selects year i want to show previous four quarters total in one bar and future four quarters in one bar

Thanks in advance

Re: forecasting in qlikview

jagan — Mon, 25 Aug 2014 01:35:28 GMT

Hi,

Attach some sample file.

Regards,

Jagan.

Re: Re: forecasting in qlikview

Mon, 25 Aug 2014 08:38:47 GMT

Hi Jagan,

FYI

Re: Re: Re: forecasting in qlikview

jagan — Mon, 25 Aug 2014 09:12:43 GMT

Hi,

PFA file for solution.

Regards,

Jagan.

Re: forecasting in qlikview

Mon, 25 Aug 2014 09:32:30 GMT

Hi Jagan,

Thanxz a lot for your work. your always awesom as usual. but i need to show by default,current quarter should be

based on system calendar (i.e, were in q3 of 2014 and next quarter would be q4 of 2014) and samewith year

Re: forecasting in qlikview

jagan — Mon, 25 Aug 2014 09:44:43 GMT

Hi,

Try like this

For Current Quarter

=Sum({<Year=, Month, quarter=, Date={'>=$(=QuarterStart(Today()))<=$(=QuarterEnd(Today()))'}>} Amount)

Regards,

Jagan.

Re: forecasting in qlikview

engishfaque — Tue, 26 Aug 2014 06:23:25 GMT

Dear Sruti,

Here is the solution. Kindly find attached files (qvw and xls).

Kind regards,

Ishfaque Ahmed