topic Re: Splitting and Put into Column in QlikView

Splitting and Put into Column

Tue, 29 Jan 2013 08:41:20 GMT

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

Re: Splitting and Put into Column

sivarajs — Tue, 29 Jan 2013 08:52:37 GMT

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

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

Re: Splitting and Put into Column

Tue, 29 Jan 2013 09:05:01 GMT

Good Day,

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

Re: Splitting and Put into Column

sivarajs — Tue, 29 Jan 2013 09:32:11 GMT

Yes you can do, something like

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

Re: Splitting and Put into Column

er_mohit — Tue, 29 Jan 2013 09:33:35 GMT

hii

see the attached file

hope it helps

Re: Splitting and Put into Column

somenathroy — Tue, 29 Jan 2013 09:35:06 GMT

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

Re: Splitting and Put into Column

SunilChauhan — Tue, 29 Jan 2013 09:46:25 GMT

see the attached file

hope this helps

Re: Splitting and Put into Column

Tue, 29 Jan 2013 10:09:36 GMT

you just need left join ...

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)