Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
cfountain72
Creator II
Creator II

Alternate Banded Colors Based on a Dimension

Hello, 

This seems like basic function, but I'm not able to find it answered anywhere. I have a straight table that I would like to alternative background colors based on a dimension (Order ID). My goal is a result like this (aka banding).  

cfountain72_0-1662395618407.png

Thanks in advance for your help,

Chris

 

 

Labels (3)
2 Replies
MatheusC
Specialist II
Specialist II

Olá,

@cfountain72  , você pode fazer da seguinte forma segue os dados do print, em expressão de cor de fundo

MatheusC_0-1662397148258.png

na expressão vc pode usar um if. como o exemplo abaixo:

if(
     ORDER ID='16535130','AZUL'
,

if(
    ORDER ID='21316563','VERMELHO'

))

OBS: Para cada coluna você irá colocar o cor de fundo com a expressão.

Caso tenho ajudado, por favor marcar como solução e deixar um like

Grato!

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
cfountain72
Creator II
Creator II
Author

Thanks MatheusC, but I don't l have any predefined list of OrderIDs. There will be hundreds or thousands, so we need an expression that automatically alternates colors.