topic Problem with Above and line chart in QlikView

Problem with Above and line chart

davoud-jelodar — Wed, 31 Jan 2018 11:11:53 GMT

I have a problem with above function.

There is a table with Symbol,PersianDateHour and Price.

I use Dim="(PersianHour, Symbol" and Exp="(Price-above(Price))/above(Price)" as changerate.

For this in "Stright Table chart" everything is Ok. but when I change it to "Line chart" there is wrong.

I do not know why and how can I fix it. You can see sample file.

davoud-jelodar — Wed, 31 Jan 2018 11:14:06 GMT

value of "(Price-above(Price))/above(Price)" grater than -1 and less than 1 but in line chart there is biger than.

sunny_talwar — Wed, 31 Jan 2018 16:46:41 GMT

Try this

Aggr((Price-above(Price))/above(Price), Symbol, PersianDateHour)

or this if you have QV 12 or above

Aggr((Price-above(Price))/above(Price), Symbol, (PersianDateHour, (NUMERIC)))

davoud-jelodar — Thu, 01 Feb 2018 03:02:13 GMT

Thank you.