Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master 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

4 Replies
Gysbert_Wassenaar

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
Master III
Master III
Author

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

Gysbert_Wassenaar

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
Anonymous
Not applicable

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