Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a table which storing the cumulative sales amount of a department by date like below:
Date | Cumulative sales amount of that month |
1-Sep-17 | 100 |
2-Sep-17 | 200 |
3-Sep-17 | 300 |
4-Sep-17 | 400 |
5-Sep-17 | 500 |
6-Sep-17 | 600 |
7-Sep-17 | 700 |
8-Sep-17 | 800 |
9-Sep-17 | 900 |
10-Sep-17 | 1000 |
11-Sep-17 | 1100 |
12-Sep-17 | 1200 |
13-Sep-17 | 1300 |
14-Sep-17 | 1400 |
15-Sep-17 | 1500 |
16-Sep-17 | 1600 |
17-Sep-17 | 1700 |
18-Sep-17 | 1800 |
19-Sep-17 | 1900 |
20-Sep-17 | 2000 |
21-Sep-17 | 2100 |
22-Sep-17 | 2200 |
23-Sep-17 | 2300 |
24-Sep-17 | 2400 |
25-Sep-17 | 2500 |
26-Sep-17 | 2600 |
27-Sep-17 | 2700 |
28-Sep-17 | 2800 |
29-Sep-17 | 2900 |
30-Sep-17 | 3000 |
1-Oct-17 | 200 |
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.
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