Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Kaushik2020
Creator III
Creator III

Background Expression not applied to column

Dear All, 

Below is my set Expression where i am applying background color as Red and Green based on Rank. 

I am using a table with ID, Name and Value. this condition is applied in Background expression for Column Value. 

if(CatId='22',
if(Rank(Num(avg(aggr(Sum({$<Year=, Month=, Day=,EmpName=, CustomCatLabel={'22'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Value), EmpCode,CatId,EmpName)),'#,##0%'))<=10,'Green',
if(Rank(Num(-avg(aggr(Sum({$<Year=, Month=, Day=, EmpName=,CustomCatLabel={'22'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Value), EmpCode,CatId,EmpName)),'#,##0%'))<=10,'Red',
Num(avg(aggr(Sum({$<Year=, Month=, Day=, EmpName=,CustomCatLabel={'22'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Value), EmpCode,CatId,EmpName)),'#,##0%'))),
if(CatId='23','White',
if(CatId='24','White',
if(CatId='25','White',
if(CatId='26','White','White'))))

Here column name has Arabic text. When applied with Id and Name column, Value is showing all Green,

with just Id, this condition works well. 

Any suggestions on what I am missing ?

thanks in advance. 

 

Labels (3)
0 Replies