Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

can any one help me

Hi can any one  help me..

This is my table data.

   

TypeIdDateAmount
Rec104-01-155000
Rec205-01-156000
Pay106-01-152000
Rec307-01-151000
Pay208-01-158000

Output:

Rec IDPay IDAmount
112000
123000
225000

is it possible?

4 Replies
MVP
MVP

first in frist out

How to find fifo order ?

Are you all working in same company or this is an interview question?

Specialist II
Specialist II

Manish Kachhia wrote:

first in frist out

How to find fifo order ?

Are you all working in same company or this is an interview question?

Hopefully the company interviewing will monitor the community to see if the answers are all the same!

Not applicable

It is an interview question.

MVP
MVP

Ok.. .Can you give an explanation on how you want to get the output?

I need to know the explanation not by words but by expression or some +/- calculation.