Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Create table...

Hello Forum,

i have a question. I have the next hire and termination table

original.jpg

I need the next output table.

final.jpg

Anyone know how to do it?

Regards

3 Replies
fkeuroglian
Honored Contributor

Re: Create table...

Hi, please can you explain more what you want? would be easier to help you

http://community.qlik.com/docs/DOC-2380

Fernando

Not applicable

Re: Create table...

Fernando,

i have a excel table with a lot of hire and termination transactions. Each line show a new transaction. I need to create a new table. It table will be to show only one line for each contract. On the new table i need to show Employee ID, Hire Date and Termination Date.

nilo_pontes
Contributor

Re: Create table...

Hi Austero,

Search for IntervalMatch function at your help file. You will find examples there.

I guess this is what you are looking for.

Regards.