Splitting and Put into Column

[#1]

Good Day Everyone,

     Can i have an Idea regarding this Problem.

Sample Data. This sample data in 1 date only 1/1/2013

Employee	Schedule	Time In-Out
John	TimeIn	8:00
Mark	TimeIn	8:10
Jess	TimeIn	8:15
John	Timout	12:00
Mark	Timeout	14:00
Jess	Timeout	15:00

And the output for Qlikview is like this

Employee	TimeIn	TimeOut
John	8:00	12:00
Mark	8:10	14:00
Jess	8:15	15:00

Your Response is Highly Appreciated.

Regards,

raem.paks

[sivarajs]

if(wildmatch(Schedule,'*TimeIn*'),Time In-Out) as TimeIn

if(wildmatch(Schedule,'*Timeout*'),Time In-Out) as TimeOut

[#3]

Good Day,

Is this can be Done on Chart Table or Pivot Table?

[sivarajs]

Yes you can do, something like

Aggr(if(WildMatch(Schedule,'*TimeIn*'),[Time In-Out]),[Time In-Out],Employee) as TimeIn

[er_mohit]

hii

see the attached file

hope it helps

[somenathroy]

Hi,

At expression level for Charts(Straight or Pivot), write

Only({<Schedule={'TimeIn'}>}[Time In-Out]) 

and

Only({<Schedule={'TimeOut'}>}[Time In-Out])

Please note also that it has been considered that 'TimeOut' would be the right word used.

Regards,

Som

[SunilChauhan]

see the attached file

hope this helps

[#8]

you just need left join ...

a:

Load

Emp,timein-Out as Time IN

from ...

where (match(Schedule,TimeIn)

Left join

Emp,timein-Out as Time OUT

from ...

where (match(Schedule,Timeout)