Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
jayeshmule
Not applicable

Create expression which counts values in year range

Hello ,

I am trying to calculate the count employees who joined between the range of two years such as Min year and Max year.

Below image contains the range selection so from this I want to select min year as 1946 and Max year 1955 and calculate count in between them. Can any body suggest me approach how to get that selected range values of year in expression as well as using Rangecount() is feasible here or not?

rangecount.png

1 Solution

Accepted Solutions
rahulpawarb
Not applicable

Re: Create expression which counts values in year range

Hello Jayesh,

If I understood your requirement then you can add one KPI chart to your application with expression as COUNT([EmployeeId])

When you do the range selection on your other chart then the KPI chart will show Total Employees within that selected range.

Please correct me if I misinterpreted.

Regards!

Rahul

4 Replies
sunny_talwar
Not applicable

Re: Create expression which counts values in year range

Are you trying to get the Min year or the value associated with Min Year? and same for max? If it is the value associated with min year... would you be able to share the expression you are using?

rahulpawarb
Not applicable

Re: Create expression which counts values in year range

Hello Jayesh,

If I understood your requirement then you can add one KPI chart to your application with expression as COUNT([EmployeeId])

When you do the range selection on your other chart then the KPI chart will show Total Employees within that selected range.

Please correct me if I misinterpreted.

Regards!

Rahul

jayeshmule
Not applicable

Re: Create expression which counts values in year range

     I needed count in between that range. With help of KPI object i was able to do it. Thank you for your help

jayeshmule
Not applicable

Re: Create expression which counts values in year range

Thank you for your help.