Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vlakeshr
Contributor

How can convert date column into month and count of that month in the table

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 noDate_ADate_BDate_C
112/7/20166/7/201712/7/2017
21/7/20171/7/20171/7/2017
32/7/20172/7/20172/7/2017
43/7/20173/7/20173/7/2017
54/7/20174/7/20174/7/2017
65/7/20175/7/20175/7/2017
76/7/20176/7/20176/7/2017
87/7/20177/7/20177/7/2017
98/7/20178/7/20178/7/2017
109/7/20179/7/20179/7/2017
1110/7/201710/7/201710/7/2017
1211/7/201711/7/201711/7/2017
1312/7/201712/7/2017

12/7/2017


Output:

   

Client no123
MonthDate_ADate_BDate_C
Jan-17222
Feb-17000
Mar-17222
Apr-17444
May-17111
Jun-17000
Jul-17000
Aug-17000
Sep-17000
Oct-17666
Nov-17222
Dec-17111
2 Replies

Re: How can convert date column into month and count of that month in the table

vlakeshr
Contributor

Re: How can convert date column into month and count of that month in the table

Thanks Bill..for Reply

Can you please tell me the script in load editor..

Community Browser