Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

first in frist out

How to find fifo order ?

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

Highlighted
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!

Highlighted
Not applicable

It is an interview question.

Highlighted
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.