Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Master
Partner - Master

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
Author

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
Partner - Creator
Partner - Creator

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.