Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

amit_saini
Honored Contributor III

Trendline based on Data

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,

AS

2 Replies
jaaldurgam
Valued Contributor

Re: Trendline based on Data

Yes Amit, its possible

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

HTH,

Sreeni

nagarjuna_kotha
Valued Contributor II

Re: Trendline based on Data

Yes,

We can Show that.

Can you share sample data ?

Community Browser