Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Colouring Stacked bar chart in qliksense with 1 dimension and 2 measures

Hi Experts,

I have 1 dimension as student Id and 2 measures as totalmarks and Reference. Reference value is 150, which is fixed. If marks is less than 150 it should be red and if it is greater than equal to 150 than it should be green in colour. I have attached the qvf file. Any help would be appreciated.

Regards,

Saugat

4 Replies
Neymar_Jr
Creator II
Creator II

Hi Saugat,

Please find attached the updated app and let me know if that works for you or not.

Regards,

Rajesh !

devarasu07
Master II
Master II

Hi,

u can write color expression like below,

if(sum(totalmarks)<150, red(), green())

Capture.JPG

Anonymous
Not applicable
Author

Hi ,

I achieved this by adding the expression in master item, and there u have a option to give colors for that specific expression.

Regards,

Saugat

Anonymous
Not applicable
Author

Hi Saugat,

When you have 2 Measures, u will get a option of stacked Bar in Appearance. There you can also get Bar color customised In Colors Tab  By Measure,  By Dimension, Multicolored,

Regards,

Rajan