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

    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.