topic Re: Chart showing previous years in QlikView

Chart showing previous years

rcorcoran — Thu, 16 Apr 2015 08:52:59 GMT

Looking for help with a line chart

I have attached a file with two line charts. It is supposed to show this year V previous 2 years and target.

Chart 1 is doing this but the expressions are hard coded with the years. What I really want is like Chart 2 which is working fine if 2014 is selected but when 2015 is selected because there is no data in yet for 2015 it is not showing any of the years. So I need this to show the previous years even if there is no data in the current year.

Any help would be appreciated

Thanks

Re: Chart showing previous years

Anonymous — Thu, 16 Apr 2015 09:03:17 GMT

I tried the follwoing Expression for year -1 and year -2 and I get the same Chart as Chart1

for year-1:

=Sum({1<[HWB Screen] ={1},RDOKey={99},ReferredYYYY={'($(=max({1}ReferredYYYY)-1))'}>}ActualValue)

Re: Chart showing previous years

MK_QSL — Thu, 16 Apr 2015 09:07:42 GMT

Label

=Max(ReferredYYYY)

Expression

=Sum({1<[HWB Screen] ={1},RDOKey={99},ReferredYYYY={'$(=Max(ReferredYYYY))'} >}ActualValue)

Label

=Max(ReferredYYYY)-1

Expression

=Sum({1<[HWB Screen] ={1},RDOKey={99},ReferredYYYY={'$(=Max(ReferredYYYY)-1)'}>}ActualValue)

Label

=Max(ReferredYYYY)-2

Expression

=Sum({1<[HWB Screen] ={1},RDOKey={99},ReferredYYYY={'$(=Max(ReferredYYYY)-2)'}>}ActualValue)

Re: Chart showing previous years

rcorcoran — Thu, 16 Apr 2015 09:13:11 GMT

Thanks so much Manish that works perfectly

Re: Chart showing previous years

rcorcoran — Thu, 16 Apr 2015 09:13:13 GMT

Thanks both of you for your help