Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Dhivaharan
Partner - Contributor II
Partner - Contributor II

Master calendar

Hi,

I constructed the master calendar for the Hiredate field,

Now my quest is to find number of hirings per month year 

Thank you

1 Solution

Accepted Solutions
Vegar
MVP
MVP

Assuming have a field containing YearMonth, then you can use that as an Dimension in a chart or table together with a measure for calculating the number of hirings. How It is calculate is depending on your data, but it could be like one of the two below 

Count(HiringID) 

 Sum(NoOfHires) 

View solution in original post

2 Replies
Vegar
MVP
MVP

Assuming have a field containing YearMonth, then you can use that as an Dimension in a chart or table together with a measure for calculating the number of hirings. How It is calculate is depending on your data, but it could be like one of the two below 

Count(HiringID) 

 Sum(NoOfHires) 

Dhivaharan
Partner - Contributor II
Partner - Contributor II
Author

Thanks for replying