Qlik Community

Qlik Sense App Development

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

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Count of month number

Hello all ,

I hve  year column and I want  month count corresponding to year

For eg 

Year    month 

Jan 19   1

Feb 19.  2

Mar 19   3

.

.

.

Dec19.   12

Jan 20.  13 

Feb 20   14

.

.

Dec20.   24 

Any ans  for this highly appreciated.

 

Regards,

Kavita 

 

3 Replies
Highlighted
Partner
Partner

Hi Kavita ,

 

I am not sure if this is what you want,but you can use the "RowNo()" to automatically create a row number.

Regards,

Paul

 

Test:
load * inline [
Year
Jan19
Feb19
Mar19
Apr19
May19
Jun19
Jul19
Aug19
Sep19
Oct19
Nov19
Dec19
Jan20
Feb20
Mar20
Apr20
May20
Jun20
Jul20
Aug20
Sep20
Oct20
Nov20
Dec20
];

Left Join (Test)
Load
Year,
RowNo() As Month
Resident Test;

 

Result:

 
 
YearMonth
Jan191
Feb192
Mar193
Apr194
May195
Jun196
Jul197
Aug198
Sep199
Oct1910
Nov1911
Dec1912
Jan2013
Feb2014
Mar2015
Apr2016
May2017
Jun2018
Jul2019
Aug2020
Sep2021
Oct2022
Nov2023
Dec2024

 

Highlighted
Specialist III
Specialist III

One solution is.

Cal:
LOAD Date(AddMonths('1/1/2019',IterNo()-1),'MMM-YY') As FYear,
	IterNo() As FMonth
AutoGenerate 1
While IterNo()<=24
; 
Highlighted
Specialist III
Specialist III

Output

commQV43.PNG