Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vishuraina
New Contributor II

Conditional Formatting basis descending/ascending of numbers in a table

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.00.20.40.70.50.80.50.50.34.0
0.20.30.40.20.70.90.50.50.03.7
0.50.40.50.80.60.40.10.70.14.1
0.20.20.10.90.50.80.30.61.04.6
1.00.60.40.30.20.80.10.00.64.2
0.30.30.30.70.80.31.00.60.75.0
0.20.00.80.90.40.00.90.00.84.1
0.50.90.50.00.00.40.80.00.84.0
0.70.40.10.70.80.80.80.30.95.5
0.80.60.20.50.50.20.60.40.23.9
4.43.83.75.85.15.55.73.75.3
6 Replies
thiago_justen
Valued Contributor III

Re: Conditional Formatting basis descending/ascending of numbers in a table

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.

Capturar1.PNG

Then, that is my result:

Capturar2.PNG

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
vishuraina
New Contributor II

Re: Conditional Formatting basis descending/ascending of numbers in a table

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
Valued Contributor III

Re: Conditional Formatting basis descending/ascending of numbers in a table

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

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
vishuraina
New Contributor II

Re: Conditional Formatting basis descending/ascending of numbers in a table

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

thiago_justen
Valued Contributor III

Re: Conditional Formatting basis descending/ascending of numbers in a table

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

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
vishuraina
New Contributor II

Re: Conditional Formatting basis descending/ascending of numbers in a table

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.

example.PNG