topic Re: Specifying multiple colors in color expressions in App Development

Specifying multiple colors in color expressions

Anonymous — Sat, 16 Nov 2024 08:37:57 GMT

I'm trying to use color expressions for a combo chart based on filter criteria in QLIK SENSE.

I can get the filter criteria to change the color, but no matter what I do, all the bars and lines in the combo chart are the same color.

Here's an example of what I'd like to do:

The combo chart has 3 metrics (sales prior year, sales current year, and percent change), one dimension (month), and one filter (company).

1. If "Acme Corp" is selected in the "Company" filter, then the first metric is light blue (#8888ff), second metric is medium blue (#0000ff) and the third metric is dark blue (#000088)

2. If "Superior Corp" is selected in the "Company" filter, then the first metric is light red (#ff8888), second metric is medium red (#ff0000) and the third metric is dark red (#880000)

3. If neither, or both, are selected the first metric is light grey (#cccccc), second metric is medium grey (#888888) and the third metric is dark grey (#555555)

Is it possible to do this? Can I do it using the order of the metrics, or do I need to specify the metric names? (The former is more general and thus easily copied and pasted)

Thank for any ideas!

Re: Specifying multiple colors in color expressions

isingh30 — Tue, 27 Feb 2018 18:32:41 GMT

Select dimension & put this expression in background color.

= if (Company = 'Acme Corp' ,LightBlue(),LightCyan())

Thank you!

Re: Specifying multiple colors in color expressions

isingh30 — Tue, 27 Feb 2018 18:34:22 GMT

Please share you data or app for better understanding.

Thank you!

Re: Specifying multiple colors in color expressions

Anonymous — Tue, 27 Feb 2018 19:52:50 GMT

Ishteep,

Thanks for looking into this for me!

The challenge is that "Company" is not a dimension in the chart at all. It is only a filter on the sheet.

I quickly mocked this up in Excel Pivot Charts. (I had to change the colors manually of course. This is just for illustration.)

Let me know if this helps clarify the question.