Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

dje071019
New Contributor

Color Expression for 2 Measures in Bar Chart

Hi,

I am creating a bar chart that compares 4 categories' current and previous scores. I would like the current score for each category to be a different color and all previous scores to be grey. However, I am having trouble using an IF statement since the score calculations require a set analysis. The formulas for current and previous scores are the following:

Current Score

(sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date))"}>}[Points_Earned])

/sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date))"}>}[Points_Possible]))

Previous Score

(sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date,2))"}>}[Points_Earned])

/sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date,2))"}>}[Points_Possible]))

Thanks,

DJE

1 Reply
Not applicable

Re: Color Expression for 2 Measures in Bar Chart

Hi

Please share your model, I cant propose a solution without it

Community Browser