Conditional Formatting basis descending/ascending of numbers in a table

[Anonymous]

Hi all,

I need help with conditional formatting of a table in Qliksense like excel in increasing/decreasing order of the numbers. Also is there a way by which the i could highlight the row/column which has max sum. Showing an example of the required data below.

0.0	0.2	0.4	0.7	0.5	0.8	0.5	0.5	0.3	4.0
0.2	0.3	0.4	0.2	0.7	0.9	0.5	0.5	0.0	3.7
0.5	0.4	0.5	0.8	0.6	0.4	0.1	0.7	0.1	4.1
0.2	0.2	0.1	0.9	0.5	0.8	0.3	0.6	1.0	4.6
1.0	0.6	0.4	0.3	0.2	0.8	0.1	0.0	0.6	4.2
0.3	0.3	0.3	0.7	0.8	0.3	1.0	0.6	0.7	5.0
0.2	0.0	0.8	0.9	0.4	0.0	0.9	0.0	0.8	4.1
0.5	0.9	0.5	0.0	0.0	0.4	0.8	0.0	0.8	4.0
0.7	0.4	0.1	0.7	0.8	0.8	0.8	0.3	0.9	5.5
0.8	0.6	0.2	0.5	0.5	0.2	0.6	0.4	0.2	3.9
4.4	3.8	3.7	5.8	5.1	5.5	5.7	3.7	5.3

[Thiago_Justen_]

I'm not sure if I really understood what you want to, but here we go:

You can do a conditional formatting background colors as you want by doing this trick (see images below)

First I'd put my conditional background color expression:

If(Sum([YTD Sales Amount])>100,LightGreen(),LightRed())

//It's a simple example. You can also use nested if.

Then, that is my result:

[Anonymous]

Hi Thiago,

Thanks for your response. I know this way of coloring but i wanted to make the color field dynamic and not restrict the formatting to a specific number say 100 as specified by you in the example. I've found a solution to this using the Rank function which would assign a rank to the numbers in increasing/decreasing order and in turn color them rank wise. Also i'd appreciate your take on the 2nd half of the problem i.e., highlighting the column/row with max sum.

[Thiago_Justen_]

I'm not sure if I understood what you want but here we go:

If you want to coloring the whole row that contains max sum, you'll need to put something like this for each dimension's and measure's color  expression (all of them):

If(Rank(Sum(YOUR_FIELD))=1,WHEREVER COLOR YOU WANT)

Is this your point? Am I missing anything?

Cheers

[Anonymous]

Thats right. I've done the same using the above expression. Thanks.

[Thiago_Justen_]

So is this solved by now? If yes, please close the thread by marking the correct response.

Cheers

[Anonymous]

First part of the problem is solved, but i'll need help with the 2nd half of the problem i.e, highlighting the row/column with max sum. Below is an example.