Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

satishqlik
Contributor

Kindly help

Hi Experts,

I'm sharing my dummy data and it contains

Emp,Date,Logintime,Gender,Route,Logintype

This scenario is actually

To allocate the cab for group of employees(1 cab for 4 employees) which is based on the

route and date and logintype and logtime and gender.

How do we achieve this(frontend/backend)???

Any suggestions will be appreciated.

PFB for your reference!!!

Tags (1)
1 Reply
satishqlik
Contributor

Re: Kindly help

I have tried with creating flags using If condition

Load *

If(count(Emp)/4=mod(count(Emp),4),'Flag1') as MyFlag

Resident maindata

Groupby

Logintype,Date,Logintime,Gender,Route;

But it is not working .....

Any suggestions will be appreciated.