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 |
