Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Contributor III

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

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