topic line Chart difficulty in QlikView

line Chart difficulty

Thu, 31 Mar 2011 11:55:50 GMT

I want to make a line chart where the date should be visible when there is change in expression.

eg. if i am saleing 200 units for first five days of month and suddenly it increases or decreases from sixth day. Then only days where change has occured that shoul be visible. how to write expression for this????

line Chart difficulty

Anonymous — Thu, 31 Mar 2011 17:14:12 GMT

I am not sure how you want to see this in a line charts but I am pretty sure you can use the "above()" function.
Something like

If (Sum(Amount) <> Above(Sum(Amount)),(Sum(Amount)))

Check the attachment to see how you can use it.

Hope this helps.

line Chart difficulty

Fri, 01 Apr 2011 03:50:37 GMT

Thank you very much Dennis

But further if I even dont want to see the days where it is same as previous. Means from 8thb day in your example to dorectly 13 where its changing next.

Thanks once again.

line Chart difficulty

Anonymous — Fri, 01 Apr 2011 06:35:53 GMT

I see what you mean.
In that case you need can not use the "Above()" function, because you have nothing to compair it with.

I don't have the answer for you right now, but I will think about it.