5 Replies Latest reply: Dec 21, 2016 7:14 AM by Rafael Souza RSS

    Doubt expression Line Chart in QlikView

    Rafael Souza

      Guys, good afternoon, I'd like to know how you can help me.

      I have the following table:


      I need to create a Line chart for each REGIONAL where only the last photo of each month is always counted

      In this way, I inserted the following specifications in the chart:

      Dimension: DTFOTO

      Expression: SUM({$<REGIONAL={'A'}>} PEND_TOTAL) / SUM({$<REGIONAL={'A'}>} CART_TOTAL)

      With the above expression, I get the percentage calculation of all the photos, however I need the chart to only count the last photo of each month (11/30/2016 and 12/30/2016)

      Can you help me?