Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Color by Expression in a Stacked Bar Chart in Qlik Sense

Hello,

PLEASE HELP!!! I have googled and youtubed looking for help and haven't found it....

    

The problem ....

Dimension - (Drill-down) Regional Training, BC , Dist, Dealer Code

Measure - Count of Students that have a "Y" status and a Count of Students that have a "N" status:

Measure 1 = Count({$<[LEVEL 1 COMPLETION]={"Y"}>} distinct SID)

Measure 2 = Count({$<[LEVEL 1 COMPLETION]={"N"}>} distinct SID)

I want to be able to write an expression (if that is the easiest way) to color by measure... N = Red and Y = Green.

It seems so simple but I can't figure it out. Please help ASAP! Thanks!

1 Solution

Accepted Solutions
mgranillo
Specialist
Specialist

Try moving [LEVEL 1 COMPLETION] as your second dimension (so you'll have two dimensions: drilldown and [LEVEL 1 COMPLETION]), make your expression Count(distinct SID), and enter your color expression as if([LEVEL 1 COMPLETION]='Y',green(),if([LEVEL 1 COMPLETION]='N',red()))

View solution in original post

5 Replies
mgranillo
Specialist
Specialist

Try moving [LEVEL 1 COMPLETION] as your second dimension (so you'll have two dimensions: drilldown and [LEVEL 1 COMPLETION]), make your expression Count(distinct SID), and enter your color expression as if([LEVEL 1 COMPLETION]='Y',green(),if([LEVEL 1 COMPLETION]='N',red()))

Not applicable
Author

Can you just write in your color by expression

If([LEVEL 1 COMPLETION]='Y',Green(),Red())

Not applicable
Author

THANK YOU!!!!!!!!!

It worked! You have no idea how much I appreciate your help and knowledge.   I changed the color expression to - if([LEVEL 1 COMPLETION]='Y',green(),red()) but your guidance got me to where I needed to go! Huge help! You Rock!

Not applicable
Author

Yes, that expression worked but I needed to first get the dimension and drill-down to be positioned correctly. Thanks for your help!

lavanyakat
Contributor II
Contributor II

Hi,

I have tried the same colour expression:

if([AMHP Out of Hours Y/N] ='Yes',black(),if([AMHP Out of Hours Y/N] ='No',green(), red()))

However as you can see from the attached image, the expression is not working on the stacked bar chart.

The 2 Measures I have for the stacked chart are:

1) SUM({<[AMHP Count Referral]={1}, [AMHP Out of Hours Y/N] ={'Yes'}>} [AMHP Count Referral])

2) SUM({<[AMHP Count Referral]={1}, [AMHP Out of Hours Y/N] ={'No'}>} [AMHP Count Referral])

Thanks,

Lav