topic Re: Start graph on specific date in QlikView

Start graph on specific date

Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

Last year I managed to create a chart with the maximum month = the month of selection and the minimum month = the selected month-12. So basically if I select april 2016, the chart would show me the results of april 2015 untill april 2016.

The expression used:

=(sum({$<Date_Year=, Date_Month=, Date_MonthYear={">=$(=Date(addmonths(Max(Date_MonthYear), -12), 'MMM-YY')) <=$(=Date(addmonths(Max(Date_MonthYear), 0), 'MMM-YY'))"}>}Sales))

The value to select is thus "Date_MonthYear".

What I would like now is a chart starting on 01/01/2015 untill the selected month. I thought this would be easy but the expression below gives me all possible values. It does not start on the 01/01/2015.

=(sum({$<Date_Year=, Date_Month=, Date_MonthYear={">=01/01/2015 <=$(=Date(addmonths(Max(Date_MonthYear), 0), 'MMM-YY'))"}>}Sales))

Can anybody help me please?

Kind regards

Re: Start graph on specific date

Kushal_Chawda — Mon, 09 May 2016 06:40:41 GMT

(sum({$<Date_Year=, Date_Month=, Date_MonthYear={">=$(=Date(Yearstart(Max(Date_MonthYear)), 'MMM-YY')) <=$(=Date(addmonths(Max(Date_MonthYear), 0), 'MMM-YY'))"}>}Sales))

(sum({$<Date_Year=, Date_Month=, Date_MonthYear={">=$(=Date(Yearstart(addmonths(Max(Date_MonthYear),-12)), 'MMM-YY')) <=$(=Date(addmonths(Max(Date_MonthYear), 0), 'MMM-YY'))"}>}Sales))

Re: Start graph on specific date

Mon, 09 May 2016 06:47:54 GMT

That is amazing.

Thank you so much!!

Re: Start graph on specific date

Kushal_Chawda — Mon, 09 May 2016 06:49:07 GMT

That's my pleasure