topic Re: Avoid showing horizontal line in chart in QlikView

Avoid showing horizontal line in chart

johngouws — Sat, 13 Feb 2016 02:08:47 GMT

Morning,

My chart shows Accumulated Targets and Sales. My expressions for Sales currently is:

=SUM({<Sales_Fin_Year={"$(=max([Display Fin Year]))"}

, Sales_Fin_Period={"$(=max(month(Today())))"}

,Date={"<$(=max(date(Today())))"}

, DocumentType={'3','4'},[Unit Sell]={'>0'} >} TotalLineSale)

I wonder if there is a way of not showing the section of Sales line, circled in black.

Any ideas are much appreciated.

Re: Avoid showing horizontal line in chart

Gysbert_Wassenaar — Sat, 13 Feb 2016 06:42:58 GMT

Click on the + in front of the expression on the expressions tab, select Background Color, and enter an expression in the Definition input field that will make the background color 100% transparent if the current value of the expression is the same as the previous one. Something like:

=If(Above(SUM({ .... }TotalLineSale))=SUM({ .... }TotalLineSale). argb(0,0,0,0), color(2))

Re: Avoid showing horizontal line in chart

johngouws — Tue, 16 Feb 2016 04:20:14 GMT

Hello Gysbert.

I was bringing in target and sales date separate. This played a bit of havoc with what I was trying to achieve in the chart. After sorting this out, your solutions works 100%, thank you.