2 Replies Latest reply: Dec 27, 2017 1:54 PM by Anibal Martinez-Sistac RSS

    Change color in charts with conditional dimensions and aggregations

    Anibal Martinez-Sistac

      I am trying with no success to create: 1) A line chart with personalized colors based in a condition, and 2) A combo chart whit conditional dimensions and colors. I am attaching a reproducible Qlik Sense example with my approaches that were not correct.

       

      1) A line chart with personalized colors based in a condition

      It is perfectly explained by Andrea Gigliotti in this thread:Change barplot color in generic dates dashboard how to create a barplot with conditional dimensions. I have used his know-how to create the following chart:

      Image1.png

      It is a simple barplot where the dimension "Date" is converted in the new dimension "Time Period" that has 3 categories: "Before", "During", and "After", based in 6 values that act as limits for "Date" and are entered by the user via "Variable Extension" in Qlik Sense. After creating the new variable, the chart is colored so that the measure "Sales" in the category "During" is highlighted in color yellow.

       

      My question here is: How can I create an expression that does not affect the other measure in the combo chart, which is "Profits"? I would like a result as the one in the next image:

       

      The measure "Profits" has green color. Nevertheless, when it intersects the "During" period it has color red. This way the visualization would be more readable for the user:

      Image2.png

      2) A combo chart whit conditional dimensions and colors.

      It is also well explained by Steve Street in this thread:color by expression - QlikSense how to create a line chart with conditional dimensions using the ValueList function. I have used his response to create the following chart:

      Image3.png

      This chart illustrates Sum(Sales) using Value List. In pseudo-code, the conditional expression would be: IF [Ship Mode] = 'Standard Class' THEN Green(), ELSE Blue(). My question here is: How can I create an expression that adds a different independent color for the 'During' Time Period? The expected result would be something like I illustrate in the following image:

      Image4.png

      I would really appreciate some help as this charts are a little bit more difficult, given that they combine conditional dimensions, and conditional independent colors in chart lists and combo charts. Thanks in advance to the community.

       

      P.D. To reproduce 100% my example please introduce the following values in the Variable Extension boxes of my app:

      "BeforeMin" = 01.05.17

      "BeforeMax" = 02.05.17

      "DuringMin" = 03.05.17

      "DuringMax" = 06.05.17

      "AfterMin" = 07.05.17

      "AfterMax" = 08.05.17

        • Re: Change color in charts with conditional dimensions and aggregations
          kaan erisen

          Hi Anibal,

           

          1) How can I create an expression that does not affect the other measure in the combo chart, which is "Profits"?

              You can not do that with standart qlik sense combo chart yet. Maybe you can find an extension on branch that serve your goal.

               Or you can change the measure to marker. It will be more readable than line.

           

          2) How can I create an expression that adds a different independent color for the 'During' Time Period?

               if((Date>=date(date#('$(vBDA_3)','DD.MM.YY'),'DD.MM.YY')) and (Date<=date(date#('$(vBDA_4)','DD.MM.YY'),'DD.MM.YY')),LightRed(),

          IF(MATCH(ValueList('First Class', 'Second Class', 'Standard Class', 'Same Day'),'First Class','Same Day','Second Class'),Blue(),LightGreen()))

           

          Untitled.png