topic Re: Trend line disable? in QlikView

Trend line disable?

Thu, 13 Mar 2014 14:52:20 GMT

Hi,

I have combo chart with trend line. Is there any way that I can disable the line up to 15-21 days. i,e for 0-7 days, 8-14 days, 15-21 days.

Please see attached. can anyone suggest me. I have below dimensions and expressions.

Dimension 1 : DaysRange

Dimension 2: =IF(Mixmatch(MaxOrder,'Crestt'),MaxOrder)

Expression 1: Count(DISTINCT {$<DateType={'LoggedDate'},Department={'0'},Flag={2}>} ID)

(Trend line)Expression 2: Count(DISTINCT {$<DateType={'LoggedDate'},DaysRange={'22-31 Days','32-60 Days','61-90 Days','91+ Days'},Flag={2}>} ID)

chiru_thota — Thu, 13 Mar 2014 14:57:47 GMT

Have you tried Chart properties --> Presentation --> Suppress Zero-values ?

SunilChauhan — Thu, 13 Mar 2014 15:03:21 GMT

Try this

Count(DISTINCT {$<DateType={'LoggedDate'},DaysRange-={'15-21 Days'},Flag={2}>} ID)

Thu, 13 Mar 2014 15:36:03 GMT

Perfect that's working.