21 Replies Latest reply: Mar 7, 2017 3:21 PM by Sunny Talwar RSS

    Gaugue with Reference Lines

    Vinicius Pedroso

      Hi

       

      I need help in Qlik Sense

       

      Iwant to make a Gaugue with my sum(sales) with 2 selections: date(by week) and place

      Not a problem so far

       

      Now I need to make 2 Reference Lines

       

      n1. - sum(sales) from the week before the selection week and place

      n2 - sum(sales) from last month same week of the selection and place

       

      Exemple:

      I selected sum(sales) of the 3º week of FEB on Brasil in the Gaugue

       

      so "n1" will show sum(sales) of 2º week of FEB

      and "n2" will show sum(sales) of 3º week of JAN


      Please need help to make Reference lines n1 and n2