3 Replies Latest reply: Feb 27, 2018 2:52 PM by Matt Chapin RSS

    Specifying multiple colors in color expressions

    Matt Chapin

      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!