Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to remove current year line value on data point ?

Hi All

My chart only have 1 expression. and it display 2013 sales trend and 2014 sales trend.

I only want 2013 sales value display at data point , how to do it ?

13 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi Paul,


Try like this


<Year={$(=year(today()))}>


Regards,

Jagan.

Not applicable
Author

Hi Mohan

if(<Year={$(=year(today()))}>,lightgray(),yellow())

I try the above expression it still not work.

Paul

jagan
Luminary Alumni
Luminary Alumni

Hi,

Then try like this

if(<Year=year(today()), lightgray(),yellow())


Make sure that Year and Year(Today()) values are in same format, i.e,


For example : 2014 in Year field and Year(Today()) = 2014


Regards,

jagan.

Not applicable
Author

Hi Mohan

Thank you very much. but today i no luck . will try again other day.