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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Quarter and expression help

Hello,

I am trying to accomplish the following in a chart:

1. Status = In Progress and End Quarter has not passed , GREEN

2. Status = Not Started and Start Quarter has passed , RED

3. Status = In Progress and End Quarter has passed , RED

My start and end quarters are 1,2,3,4 in the database. How do I compare to current quarter?

I have this working so far

=if(Status='Not Started' and START_QUARTER>1,RGB(255,153,153), IF(Status = 'In-Progress',RGB(0,255,0)))

Can anyone suggest how to get three conditions working in one column?

Thanks.

1 Reply
alexandros17
Partner - Champion III
Partner - Champion III

if(cond1, RGB(...),

if(cond2, RGB(...),

if(cond3, RGB(...)

, RGB())

)