topic Re: Conditional color in table box in QlikView

Conditional color in table box

Tue, 30 Sep 2014 11:24:36 GMT

Hi all,

my tablebox looks like the following:

Product	Discount
A	0.3
B	0.19
A	0.34
A	0.2
B	0.11
B	0.14

and so on..

Now I would like to color the highest 30% discount values in red. But not the highest 30% of all products combined, but for every product individually. So in this example the 2nd and 3rd row (highest % of A and B) should be red, and not 1st / 3rd.

Hope my concern is clear.

Thank you in advance. Best regards!

Re: Conditional color in table box

Michael_Tarallo — Tue, 30 Sep 2014 15:03:26 GMT

Hi Ludwig -

Is this for Qlik Sense or QlikView? - Just want to make sure as the process is similiar, but how you apply it is different.

please let us know.

Mike

Re: Conditional color in table box

Wed, 01 Oct 2014 06:43:46 GMT

I'm sorry I mixed that up. This is for QlikView!

Ludwig

Re: Conditional color in table box

Michael_Tarallo — Wed, 01 Oct 2014 11:45:39 GMT

Hi Ludwig - OK - I will move this to the appropriate forum.

In the mean time - check out this video that may help you with conditional styling in QlikView.

Qlikview Pivot with Conditional Formatting by RFB 16 - YouTube

Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike

Re: Conditional color in table box

Wed, 01 Oct 2014 11:47:50 GMT

Thanks .. Much helped!

Re: Conditional color in table box

Wed, 01 Oct 2014 12:24:23 GMT

Thank you for the link, but unfortunately it does not solve my problem.

As I mentioned, I do not want to color the overall lowest values, but the lowest values for each product individually.

Is it clear what I mean? Thank you for your help !

Re: Conditional color in table box

Tue, 07 Oct 2014 13:59:08 GMT

Anyone to help me?

Thank you!

Re: Re: Conditional color in table box

jerem1234 — Tue, 07 Oct 2014 14:55:29 GMT

Hi Ludwig,

Please find attached. I used a straight table with dimensions Product and Discount. Under the Background Color and Text Color for the dimension Discount, I used the following expressions:

For the max Discount only:

Background Color:

=if(Discount=max(total <Product> Discount), red())

Text Color:

=if(Discount=max(total <Product> Discount), white())

For the top 30% when the table is sorted by Product, then Discount:

Background Color:

=if(rank(sum(Discount))<=max(total aggr(rank(sum(Discount)), Product, Discount))*.3, red())

Text Color:

=if(rank(sum(Discount))<=max(total aggr(rank(sum(Discount)), Product, Discount))*.3, white())

For the top 30% when the table is sorted by just Discount Descending:

Background Color:

=if(aggr(rank(sum(Discount)), Product, Discount)<=max(total aggr(rank(sum(Discount)), Product, Discount))*.3, red())

Text Color:

=if(aggr(rank(sum(Discount)), Product, Discount)<=max(total aggr(rank(sum(Discount)), Product, Discount))*.3, white())

I added some values to the data in order for the top 30% to actually show colors.

Hope this helps!

Re: Conditional color in table box

Fri, 20 May 2016 06:34:50 GMT

This post really helped. Thanks !