Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
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