topic Re: Pivot Table Conditional Formatting in QlikView

Pivot Table Conditional Formatting

adamwigley — Fri, 15 Nov 2024 23:53:28 GMT

Hi,

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):

Any help would be much appreciated.

Thanks,

Adam

Re: Pivot Table Conditional Formatting

Kushal_Chawda — Wed, 30 Sep 2020 12:28:57 GMT

@adamwigley try below background color expression for [Avg Price]

=if(after(total Your_Avg_Price_expression)<= Your_Avg_Price_expression, green(),red())

Re: Pivot Table Conditional Formatting

adamwigley — Wed, 30 Sep 2020 15:00:11 GMT

Hi @Kushal_Chawda,

Thanks for responding - the solution you provided worked perfectly! I just tweaked it to stop it from colouring everything in as per below:

=If(After(TOTAL [Avg Price]) > [Avg Price], LightRed()
,If(After(TOTAL [Avg Price]) < [Avg Price], LightGreen()))

Thanks again,

Adam