topic Re: Straight Table - Calculate Mini Chart Trend in QlikView

Straight Table - Calculate Mini Chart Trend

jmonroe918 — Wed, 25 Nov 2020 16:16:04 GMT

I have a Straight Table that displays a Mini Chart showing a 6 month trend of monthly data for each row. I would like to add a column with a visual indicator (an arrow image) that will read the last 3 months of the Mini Chart data and indicate if they are all trending downward (show a down arrow) or trending upward (up arrow). If possible, if the trend is flat display a sideways arrow.

I haven't been able to figure out how to associate the value with each of the last 3 months of the trend.

Please find attached a sample of the qvw and the data source.

Thanks

Jeff

Re: Straight Table - Calculate Mini Chart Trend

swuehl — Fri, 27 May 2016 17:48:59 GMT

Maybe you can use this attached sample as a starting point.

Re: Straight Table - Calculate Mini Chart Trend

kkkumar82 — Fri, 27 May 2016 17:56:31 GMT

Hi Jeffrey,

Not sure about the expression how to get it , but you can take one more expression, "Representation" as Image

and goto the expression definition editor

write an if condition based on the if condition and use the 'qmem'

Hope you got the point how to get arrows , also check " advanced" button.