Different Background color based on 80% sales out of total sales in Table box. How to do this?

[MuraliPrasath]

I have a table that needs a background color of 80 percentage sales are in Yellow color and rest are in blue color.

how to achieve this in Qlik Sense. 

[mfarsln]

Hi,

Try below code;

if(
RangeSum(above(TOTAL (sum(Sales)/sum(total Sales)), 1, RowNo(TOTAL)))<=0.8,yellow(),blue()
)

You should add this to every column's background color expression tab.

[MuraliPrasath]

Hi,

This is not working, if I apply this to my Table box then my sorting is not working. 

If we use Above function then sorting will not work. Any other fix for this? thanks for your try so far. 🙂

[mfarsln]

Hi,

What is your sorting expression?

[MuraliPrasath]

Hi,

My sorting orders are 

1. Total Sales%

2. Sales

[mfarsln]

Hi,

Can you try below expression?

Aggr(
    If(Rangesum(Above(Sum(Sales)/Sum(total Sales),1,RowNo()))<=0.8, yellow(),
           blue()),
    (ID,(=Sum(Sales)/sum(total Sales),Desc))
)