topic Re: Forecast for current year in QlikView

Forecast for current year

Anonymous — Thu, 29 Mar 2018 07:42:51 GMT

Hello everyone,

I want to show dotted line for current year in line chart.

i am not getting how to show expression for current year.

i used below exp but it show dotted line after current date but i want show for current year(not selected year)

=IF(date>Today(),'<s3>','<s1>')

Thanks.

MK_QSL — Thu, 29 Mar 2018 07:57:01 GMT

IF(Year(OrderDate) = Year(Today()),'<s3>','<s1>')

Replace OrderDate with your Date Field

Make sure that you have to use this expression in Line Style

Anonymous — Thu, 29 Mar 2018 09:30:27 GMT

Perfect.. Thank you Manish