topic Re: Trendline based on Data in QlikView

Trendline based on Data

amit_saini — Wed, 30 Sep 2015 06:03:19 GMT

Hi Folks,

Is it possible to get the trendline in a way that it just considers the values that are already there e.g. when we have data from Jan. – Sep. only the data from Jan to Sep and not from Jan to December?

My Trendline is based on expression := sum(Sales)

Thanks,

Re: Trendline based on Data

SreeniJD — Wed, 30 Sep 2015 06:06:14 GMT

Yes Amit, its possible

you have to use sum(if(sales)>0) kind of expression..

HTH,

Sreeni

Re: Trendline based on Data

nagarjuna_kotha — Wed, 30 Sep 2015 06:08:34 GMT

Yes,

We can Show that.

Can you share sample data ?