1 Reply Latest reply: Jan 17, 2017 3:44 AM by Girirajsinh Vaghela RSS

    Select the last day of the month and the related Sales figures in the bar chart

    Jacky Shing

      Hi all,

       

      I have a table which storing the cumulative sales amount of a department by date like below:

       

      DateCumulative sales amount of that month
      1-Sep-17100
      2-Sep-17200
      3-Sep-17300
      4-Sep-17400
      5-Sep-17500
      6-Sep-17600
      7-Sep-17700
      8-Sep-17800
      9-Sep-17900
      10-Sep-171000
      11-Sep-171100
      12-Sep-171200
      13-Sep-171300
      14-Sep-171400
      15-Sep-171500
      16-Sep-171600
      17-Sep-171700
      18-Sep-171800
      19-Sep-171900
      20-Sep-172000
      21-Sep-172100
      22-Sep-172200
      23-Sep-172300
      24-Sep-172400
      25-Sep-172500
      26-Sep-172600
      27-Sep-172700
      28-Sep-172800
      29-Sep-172900
      30-Sep-173000
      1-Oct-17200
      2-Oct-17

      400

      And i just want to display a bar chart showing the last date of the month and the related figures on the last day. And because i am new to Qlik sense and doesnt know much about scripting. Can i use the built in function in the visual creation to make it? like using the function "monthend".

       

      Thanks for answering.