Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can convert date column into month and count of that month in the table? In Qliksense
Please find the attached excel for reference. and input and output details
Input :
Client no | Date_A | Date_B | Date_C |
1 | 12/7/2016 | 6/7/2017 | 12/7/2017 |
2 | 1/7/2017 | 1/7/2017 | 1/7/2017 |
3 | 2/7/2017 | 2/7/2017 | 2/7/2017 |
4 | 3/7/2017 | 3/7/2017 | 3/7/2017 |
5 | 4/7/2017 | 4/7/2017 | 4/7/2017 |
6 | 5/7/2017 | 5/7/2017 | 5/7/2017 |
7 | 6/7/2017 | 6/7/2017 | 6/7/2017 |
8 | 7/7/2017 | 7/7/2017 | 7/7/2017 |
9 | 8/7/2017 | 8/7/2017 | 8/7/2017 |
10 | 9/7/2017 | 9/7/2017 | 9/7/2017 |
11 | 10/7/2017 | 10/7/2017 | 10/7/2017 |
12 | 11/7/2017 | 11/7/2017 | 11/7/2017 |
13 | 12/7/2017 | 12/7/2017 | 12/7/2017 |
Output:
Client no | 1 | 2 | 3 |
Month | Date_A | Date_B | Date_C |
Jan-17 | 2 | 2 | 2 |
Feb-17 | 0 | 0 | 0 |
Mar-17 | 2 | 2 | 2 |
Apr-17 | 4 | 4 | 4 |
May-17 | 1 | 1 | 1 |
Jun-17 | 0 | 0 | 0 |
Jul-17 | 0 | 0 | 0 |
Aug-17 | 0 | 0 | 0 |
Sep-17 | 0 | 0 | 0 |
Oct-17 | 6 | 6 | 6 |
Nov-17 | 2 | 2 | 2 |
Dec-17 | 1 | 1 | 1 |
Looks like you need monthname - script and chart function ‒ Qlik Sense
Thanks Bill..for Reply
Can you please tell me the script in load editor..