Hiding a line in a chart

[#1]

Hi,

I am trying to make a chart's line transparent when it refers to future dates. The dimension of the chart is xDate, and the line is given by the accumulated sum(Sales). To do so, I've tried to change the background color in the expressions tab using this definition:

if(xDate > $(vToday), ARGB(0,0,0,0))

For some reason it makes the line transparent for just a few dates that are totally unrelated with the variable vToday (defined as =today()).

Any help would be much appreciated.

[sunny_talwar]

How about this

If(xDate > vToday, ARGB(0,0,0,0))

or

if(xDate > Today(), ARGB(0,0,0,0))

[#3]

I tried, but none of the above solutions work.

[sunny_talwar]

Have you made sure that you date field is correctly read by QlikView?

Why don’t my dates work?

Get the Dates Right‌

If fixing the dates doesn't work (or if they are not an issue), would you be able to provide a sample to help you better?

[MK9885]

Have you used the above expressions in conditional statement box?

Add the expressions to your conditional expression and check if it's working or not.

[Digvijay_Singh]

Not sure but $ expansion might have made numeric calculation, try apostrophe around $(vToday) -

if(xDate > '$(vToday)', ARGB(0,0,0,0))

[sunny_talwar]

I doubt this would work if this did not work:

if(xDate > Today(), ARGB(0,0,0,0))

[Digvijay_Singh]

Right, this should have worked.