5 Replies Latest reply: Aug 19, 2018 2:45 AM by nikhil garg RSS

    Issue regarding Gauge chart

    nikhil garg

      Hello All,

      I am working on Gauge chart in Qliksense. I have used reference lines in Gauge chart. I am using following expression:

      "Sum({<Year = {'$(vPrevYear)'}, MonthNumber = {'<=$(=vCurMonth)'}, [Transaction Type] = {'Sales'}>}Amount)"

      where "$(vPrevYear)" = '2017'. But issue i am facing is this is working when i am selecting any year in the filter. But i have make the expression such that it should always work even if Year value not selected in the Year Filter. can anyone help em in this?

      vPrevYear =Year(Date(Today(), 'MM/DD/YYYY'))-1

      vCurMonth = Num(Month(Today()))