9 Replies Latest reply: Jul 9, 2016 11:54 AM by Sunny Talwar RSS

    How to show the max date with different color in charts?

    oytun tunçel

      Hi,

       

      I am trying to show the max quarter(date) with a different color in my bar chart. But, I am new to Qlik Sense scripting and I unfortunately i could find no way. Does anybody know how to do that? I my model, i could only show the selected quarter with different color. But, by default i would like to show the max quarter with red color. I also still want to keep the preexisting functionality (When any other quarter is selected it should show the selected one with different color). You could find the screenshot below:

       

      The color expression I use is like this:

      if(getselectedcount(Dönem)>0,if(isnull(only(Dönem)),rgb(16,26,42),rgb(239,38,54)),if(isnull(only(Dönem)),rgb(239,38,54),rgb(16,26,42)))

       

      Thanks a lot in advance.

      Best Regards,

      Oytun

      qlik com.png