Comparing Tables with Colors

Learnerr — Fri, 03 Jun 2022 11:21:09 GMT

Hi experts,

I would like to compare yeears' sellings for months.

For example i am going to choose January and want to see in this table how was it like in 2021 and 2022.

Also ı would like to compare the values with colors.

I mean if 2022 january> 2021 January make the related column green.

How can i do that comparision analysis?

Best Regards.

Re: Comparing Tables with Colors

Marijn — Thu, 09 Jun 2022 11:13:02 GMT

Hi @Learnerr,

It would be possible to achieve this with the month and a valuelist for the years as dimensions.

Dimension 1:
=valuelist(2021,2020)

Dimension 2:
=Month

Expression:

if(valuelist(2021,2020)=2021,
sum( {$< Year={2021}>} sales),
if valuelist(2021,2020)=2020,
sum( {$< Year={2020}>} sales)
))

Then right click on the expression column in the table, and click 'Custom format cell'. Click on 'Background color', then 'Calculated' and use the expression:
if( sum( {$< Year={2021}>} sales) > sum( {$< Year={2020}>} sales),green() )

Hope it helps!

topic Re: Comparing Tables with Colors in QlikView

Comparing Tables with Colors

Re: Comparing Tables with Colors