forecasting in qlikview

[#1]

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

[jagan]

Hi,

Attach some sample file.

Regards,

Jagan.

[#3]

Hi Jagan,

FYI

[jagan]

Hi,

PFA file for solution.

Regards,

Jagan.

[#5]

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

[jagan]

Hi,

Try like this

For Current Quarter

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

Regards,

Jagan.

[engishfaque]

Dear Sruti,

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

Kind regards,

Ishfaque Ahmed