Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Uploads getting stuck in the virus scanner. We are investigating.
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Issue with conditional formatting


I`ve come across following conditional formatting issue in Qlik, and I am stuck with resolving it, maybe you know how to fix it? Here are the conditions I am using:


a. Table containing 1 Dimension and 5 Metrics - visualizing data in table format

b. For conditional formatting I am using following syntax:  if(rank(count(xxxxxx)) < 4, rgb(204, 255, 204))


This set up works fine and TOP 3 is always marked with respective colors. 

HOWEVER - after adding additional column with text only : =if(url='www.abc.html','2020-01-21 - Example','To be updated') conditional formatting goes crazy and instead of marking TOP 3 it marks all columns in table


Does anyone have an idea how to fix it?





Labels (3)
2 Replies

since you need two different values qlik must read that as 2 different values. For that, you may use like. But not really sure, how come Colors and strings are together if you need 2 expression's as single 🙂

if(Match(url, 'www.abc.html', '2020-01-21 - Example'), 'To be updated')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Contributor II
Contributor II


it came out to be pretty simple to resolve it

=if(rank(total count(metric),3,0) < 4, rgb(204, 255, 204))

added two parameters according to Rank function definition - now it works fine - i.e. rank is based on total of single column