1 Reply Latest reply: Aug 28, 2017 2:02 PM by satish qlik RSS

    Kindly help

    satish qlik

      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!!!

        • Re: Kindly help
          satish qlik

          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.