topic Re: Qlik Sense conditional coloring based on highest values in column in App Development

Qlik Sense conditional coloring based on highest values in column

Anonymous — Sun, 17 Dec 2017 21:24:47 GMT

Hello,

I would like to highlight the highest values in the columns of my pivot. (gradient from largest to smallest) How do i do that?

Re: Qlik Sense conditional coloring based on highest values in column

luismadriz — Mon, 18 Dec 2017 01:34:10 GMT

Hi Mikko,

Let's say your measure is called Sum(MeasureValue), and those numbers you have there from 1 to 29, let's call them RowID. And that you want the lowest in Red and the highest in Yellow,

Then you could use this formula on the colour expression (background or text)

=Colormix1(

(sum(MeasureValue)-$(=min(aggr( sum(MeasureValue), RowID))))/

$(=(max(aggr( sum(MeasureValue),RowID))-min(aggr( sum(MeasureValue),RowID)))),Red(),Yellow()

)

Cheers,

Luis

Re: Qlik Sense conditional coloring based on highest values in column

luismadriz — Mon, 18 Dec 2017 01:35:24 GMT

It'll look something like this:

I hope this helps,

Cheers,

Luis

Re: Qlik Sense conditional coloring based on highest values in column

luismadriz — Tue, 19 Dec 2017 23:26:00 GMT

Hi Mikko,

Have you been able to check it out?

Please let me know,

Luis

Re: Qlik Sense conditional coloring based on highest values in column

Anonymous — Wed, 20 Dec 2017 11:12:13 GMT

Hello,

not working. the measure value is an aggregated one and the row is day(date).

And as you see i have multiple values in one column and i want to highlight the values within the columns (high to low in column)

thanks

Re: Qlik Sense conditional coloring based on highest values in column

luismadriz — Wed, 20 Dec 2017 23:31:49 GMT

Hi,

Can you share sample data and your aggregation formula to see if I can reproduce?

Luis

Re: Qlik Sense conditional coloring based on highest values in column

luismadriz — Fri, 22 Dec 2017 03:20:07 GMT

Hi Mikko, which one?

Re: Qlik Sense conditional coloring based on highest values in column

luismadriz — Wed, 27 Dec 2017 23:31:22 GMT

Hi Mikko,

Please let me know if you're still interested in solving this one. If so, please share sample data and the expressions you're using to calculate dimensions and measures so I can adapt the color expression

This is the expression I used for the second option (Comparing cell against column)

=Colormix1(

((sum(MeasureValue)-min(TOTAL <RowID> aggr(sum(MeasureValue),RowID,Date2)))

/ (max(TOTAL <RowID> aggr(sum(MeasureValue),RowID,Date2))

-min(TOTAL <RowID> aggr(sum(MeasureValue),RowID,Date2)))),White(),Green()

)

I hope this helps,

Cheers,

Luis

Re: Qlik Sense conditional coloring based on highest values in column

Anonymous — Thu, 28 Dec 2017 23:00:46 GMT

sorry, been busy. I will try out the latter option and let you know how it goes.