Discussion Board for collaboration on QlikView Layout & Visualizations.
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???
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.
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???
I have no idea what you're asking. But Qlikview can't calculate results from data that's not loaded in the document.
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.