I have created a pivot table which looks at sales by product groups and compares data over the past 3 x years. this was a report created in Excel they wanted me to recreate in Qlikview. All OK accept that in Excel, they use conditional formatting to look at the latest average selling price and see if it is larger or smaller than the previous year. This previous year's average selling price is then compared to the year before that, each time highlighting red if lower or green if above the previous years price.
I have no idea if Qlikview can do this or where I would start.
A screenshot of what my Qlikview application looks like is below, I have manually highlighted how I would want to use conditional formatting to highlight the data (in red and green):