Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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.