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.
Not applicable

Grouping Results

I have these columns:

Employee IDDatesLocation
1231/1/2016San Jose
1231/2/2016San Jose
1231/5/2016Seattle
1231/6/2016San Jose


I want a Table that shows me data in this format:


Location NameEmployees with more than 2 days of travel in Location
San Jose1
Seattle0


I am struggling with the last column 'Employees with less than 30 days of travel'. Can someone help?

2 Replies
rittermd
Not applicable

Re: Grouping Results

I don't see that column in your example.  If it should be in the 2nd table I'm not exactly sure how you want to display this as this table is based on location and not on employee.

I'll try to help if you can provide more information.

bellamae
Not applicable

Re: Grouping Results

What expression did you use to get 'Employees with more than 2 days of travel in location'?