Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

1 Reply
girirajsinh
Creator III
Creator III

Hi Jacky

You may load your data this way,

DAY_KEY is optional.

and on BAR chart you can use DAY_DATE as Dimension

and  measure as

Or

Hope that helps