topic Re: How to create a customized trend line in a chart? in QlikView

How to create a customized trend line in a chart?

Tue, 24 Jun 2014 14:10:39 GMT

Hi, I need to create a customized linear trend line of the graph shown below:

My trend line should start from the value of "gen-mar 2008" (aproximately 0 in this case) and go straight to the value of "lug-set 2013" (aproximately 1,300,000). How can I do that? Thanks.

Re: How to create a customized trend line in a chart?

Gysbert_Wassenaar — Tue, 24 Jun 2014 14:27:45 GMT

Add another expression. Something like =if(Month=min(total Month) or Month=max(total Month), sum(Value)). And don't suppress Zero-Values.

Re: How to create a customized trend line in a chart?

alexandros17 — Tue, 24 Jun 2014 14:29:07 GMT

La cosa più semplice che mi viene in mente è quella di caricare con un load inline una serie di valori da utilizzare poi come espressione:

quaklcosa simile a:

load * inline [

mese, qty

gen-mar 2008, 0

apr-mag 2008, 1000

..... e così via fino al tuo valore

];

fammi sapere

Re: How to create a customized trend line in a chart?

Tue, 24 Jun 2014 14:44:33 GMT

It's not my case, the dimension is dynamic as is the range of months.

Re: How to create a customized trend line in a chart?

Wed, 25 Jun 2014 08:34:20 GMT

My chart is dynamic, the user can select the period of analysis and through the set analysis i check the dates. If I understood well I should write something like this:

if(Dimension1='gen-mar 2008' or Dimension1='lug-set 2013', sum(Value)).

Is that correct?

Re: How to create a customized trend line in a chart?

Wed, 25 Jun 2014 10:18:43 GMT

I solved writing this:

=If(Only({$<DATE={">=$(vDateMin)<=$(vDateMax)"}>} MonthName(DATE))=MonthName('$(vDateMin)')

Only({$<DATE={">=$(vDateMin)<=$(vDateMax)"}>} MonthName(DATE))=MonthName('$(vDateMax)') ,

Sum({$<DATE={">=$(vDateMin)<=$(vDateMax)"}>} VALUE)

)

Where vDateMin and vDateMax are variables edited by the user, and MonthName(DATE) is the calculated dimension of the chart.