Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using an Expression to set the color of a Measure in a pie chart based on a dimension. The dimension could be one of three options. This will work for dimension option - If(Dimension_A = "ABC, Blue() - For the three options I've tried
If(Dimension_A = "AAA", Blue() Or If(Dimension_A = "BBB, Red() Or If(Dimension_A = "CCC, Yellow().
This does not work. Can you help me with the correct syntax? Thank you.
not an or but an if ....else....else as Sunny already suggested
or a pick match
Pick(Match(Dimension_A, 'AAA', 'BBB', 'CCC'), Blue(), Red(), Yellow())
Try with single quotes:
If(Dimension_A = 'AAA', Blue(),
If(Dimension_A = 'BBB', Red(),
If(Dimension_A = 'CCC', Yellow())))
not an or but an if ....else....else as Sunny already suggested
or a pick match
Pick(Match(Dimension_A, 'AAA', 'BBB', 'CCC'), Blue(), Red(), Yellow())
Thank you. I received two answers, both worked.
Thank you. I received two answers, both worked. I like Pick(Match....
Great
You can always provide a helpful answer for something that helped
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny