topic Re: Year dimension should show all last years in QlikView

Year dimension should show all last years

Thu, 27 Mar 2014 04:32:56 GMT

Hi all,

I have year as dimension and measure as sales. For example, I have years 2011,2012,2013,2014. So if I select 2014, it should all last years also; when I select 2013, it should show 2013/12/11. Also if there are total 10 years in the data, I want to keep it limited upto last five years including the selected year.

Please advise.

BR,

SAK

Re: Year dimension should show all last years

CELAMBARASAN — Thu, 27 Mar 2014 05:05:30 GMT

try this

=Sum({<Year={">=$(=Max(Year)-4)<=$(=Max(Year))"}>}Sales)

Re: Year dimension should show all last years

Thu, 27 Mar 2014 05:13:29 GMT

Also, I dont want to get it affected by the selection in months and quarters list boxes. Please advise.

Thanks!

Re: Year dimension should show all last years

PrashantSangle — Thu, 27 Mar 2014 05:25:16 GMT

Hi,

Nullify your Month Field in above expression

Try this

=Sum({<Year={">=$(=Max(Year)-4)<=$(=Max(Year))"},Month=>}Sales)

=Sum({<Year={">=$(=Max(Year)-4)<=$(=Max(Year))"},Month={*}>}Sales)

Regards,

Re: Year dimension should show all last years

CELAMBARASAN — Thu, 27 Mar 2014 06:05:28 GMT

in set analysis using "FieldName=", will ignore the selections in that field

=Sum({<Year={">=$(=Max(Year)-4)<=$(=Max(Year))"}, Month=, Quarter=, Day=, Week=>}Sales)

Hope it helps