3 Replies Latest reply: Jul 20, 2015 12:30 PM by Sunny Talwar RSS

    How to set KPI chart to = 0 when no month filter is selected?

      Hi all,

       

      I'd like to know how to set a KPI chart to equal 0 when a month dimension filter is not selected, and also when multiple months are selected (basically, only show a value when one and only one month is selected, otherwise default to "0"). What would a generic expression modifier look like that would accomplish this?

       

      Here is the current sample expression:

       

      Sum({$<PERIOD = P(LAG1MONTH), BRAND = {'QLIK'}>} [SALES VALUE EUR])

       

      Thanks,

      Kendrick