data is not coming properly for two axis chart...

Wed, 28 Oct 2015 11:34:01 GMT

Dear All.

I want to apply the thisyear expression in given chart with growth but the data is not coming properly...

PFA

Thanks

Re: data is not coming properly for two axis chart...

Gysbert_Wassenaar — Mon, 09 Nov 2015 14:49:52 GMT

=(SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},

Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}Date))"}>}Values )/10000000) / (Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)}

,Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-12))"}

>}Values )/10000000)-1

topic Re: data is not coming properly for two axis chart... in QlikView

data is not coming properly for two axis chart...

Re: data is not coming properly for two axis chart...