topic Creating Chart to reflect different time frames in QlikView

Creating Chart to reflect different time frames

cjett7769 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to create a line chart that will allow the user to review different time frames of data. For example, if the user selects fiscal year 2016, I want the chart to populate the data for fiscal 2016 and 2015. I would also like it if the chart was able to not only do years, but months as well. For example, if the user selects Fiscal year 2016 June, I would want the chart to show data for Fiscal year 2016 June and Fiscal year 2015 June.

Re: Creating Chart to reflect different time frames

Anil_Babu_Samineni — Thu, 01 Dec 2016 16:10:13 GMT

I assume, You want only for this year and Last Year

Sum({<Year, [fiscal year] = {"$(='>=' & Max([fiscal year] - 1) '<=' & Max([fiscal year])))"} >}Sales)

Following your expression for month vs month, year vs year should be:

sum({<[fiscal year] ={$(=max(Num(Year(Date(Today())))-1)), $(=max(Num(Year(Date(Today())))))}, FiscalPeriod={$(=max(Num(Month(Date(Today())))))}>} Sales)