Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

amit_saini
Honored Contributor III

Trend line straight and not swinging

Hi Folks ,

I'm using this expression for Trend line :

if(sum([Inventory $])>0,sum([Inventory $]))

But I want this line to be straight instead of swinging.  Any suggestion???

Thanks,
AS

Tags (1)
4 Replies

Re: Trend line straight and not swinging

Enable the Lineair trendline for that expression and set the background color for the expression to red(0) so it becomes transparent. Only the lineair trendline will be shown that way.

comm189534.png


talk is cheap, supply exceeds demand
amit_saini
Honored Contributor III

Re: Trend line straight and not swinging

Hi Gysbert,

Yes I have already tried this approach, but my user want to restrict this line based on availability of data.

Not sure is this possible or not???

Thanks,
AS

Re: Trend line straight and not swinging

I have no idea what you're asking. But Qlikview can't calculate results from data that's not loaded in the document.


talk is cheap, supply exceeds demand
Highlighted
balkumarchandel
Valued Contributor II

Re: Trend line straight and not swinging

I think you are looking for trend line containing total inventory(With all the months ).

for example in your current scenario you are using month as dimension so your trend is changing monthly basis.

if I understand you correct .. you use

Sum(Total [Inventory $])

you don't need if condition as well.

Lets explain your requirement once again with example if this is not the solution you are looking for.

Thanks

BKC

Community Browser