topic Re: Last year data not showing in QlikView

Last year data not showing

prma7799 — Wed, 21 Sep 2016 10:35:10 GMT

Dear All,

I am able to see last year data.

PFA...

Re: Last year data not showing

sunny_talwar — Wed, 21 Sep 2016 10:43:25 GMT

May be this:

Sum({<Year=, MonthName=, Quarter=, Flag = {'Values'} , Date={">=$(=Date(YearStart(Max(Date), -1), 'MMM-YY'))<=$(=Date(AddYears(Max(Date), -1), 'MMM-YY'))"}>} Amount)/10000000

Re: Last year data not showing

prma7799 — Wed, 21 Sep 2016 10:54:40 GMT

Hi Sunny,

After selection there is not showing any data for LY

Re: Last year data not showing

agomes1971 — Wed, 21 Sep 2016 10:57:07 GMT

Hi,

expression for only the last year:

Sum({< Flag = {'Values'}, Year={"$(=max({1} Year))"} >} Amount)/10000000

HTH

André Gomes

Re: Last year data not showing

sunny_talwar — Wed, 21 Sep 2016 11:07:17 GMT

Try this:

Sum({<Year=, MonthName=, Quarter=, FiscalYear =, FinancialYear =, Flag = {'Values'} , Date={">=$(=Date(YearStart(Max(Date), -1), 'MMM-YY'))<=$(=Date(AddYears(Max(Date), -1), 'MMM-YY'))"}>} Amount)/10000000

Re: Last year data not showing

prma7799 — Wed, 21 Sep 2016 11:19:40 GMT

Sunny data is not coming right ....

Please check....

if i check...

Re: Last year data not showing

sunny_talwar — Wed, 21 Sep 2016 11:34:52 GMT

How about this:

Sum({<Year=, MonthName=, Quarter=, FiscalYear =, FinancialYear, Flag = {'Values'} , Date={"$(='>=' & Date(YearStart(Max(Date), -1, 4), 'MMM-YY') & '<=' & Date(AddYears(Max(Date), -1), 'MMM-YY'))"}>} Amount)/10000000

Re: Last year data not showing

agomes1971 — Wed, 21 Sep 2016 11:36:59 GMT

Hi,

if you based on year selections

Hi,

expression for only the last year:

Sum({< Flag = {'Values'}, Year={"$(=max({$} Year))"} >} Amount)/10000000

HTH

André Gomes

Re: Last year data not showing

Anonymous — Wed, 21 Sep 2016 11:40:37 GMT

have a look to that Expression:

=Sum({<FinancialYear=,FiscalYear=,Year=, MonthName=, Quarter=, Flag = {'Values'} ,Date={">=$(=date(addyears(Min(Date),-1),'MMM-YY'))<=$(=date(addyears(Max(Date),-1),'MMM-YY'))"}>} Amount)/10000000

Re: Last year data not showing

prma7799 — Wed, 21 Sep 2016 11:46:10 GMT

Sunny this expression takes data only for few months ...

Can you please give me simply expression for YTD MTD LYTD LMTD...

Re: Last year data not showing

sunny_talwar — Wed, 21 Sep 2016 12:17:56 GMT

Have you already seen this thread?

YTQ, QTD, MTD and WTD‌