currency conversion using peek

Fri, 10 May 2013 19:23:21 GMT

Hi Experts,

I am stuck in some place. Attached the necessary docs.

There are 3 tables loaded. Rupees,orders,order details. Rupees table has some dates with rate value. Orders has some order dates. Order details having price.

For example : I will get by doing necessary joins and peek usage by below.

currently did this much. Also getting previous rate if there is no rate. but not for all rows. Only for one previous record fetching. The same thing is there in file attached.

date price rate newrate

1-jan-1994 $10.50 52 52

2-jan-1994 $25.50 - 52

3-jan-1995 $21.76 -

4-jan-1996 $54.87 53 53

But I want output like below.

date price rate newrate

1-jan-1994 $10.50 52 52

2-jan-1994 $25.50 - 52

3-jan-1995 $21.76 - 52

4-jan-1996 $54.87 53 53

Thanks

Kindly help.

Thanks

Re: currency conversion using peek

Gysbert_Wassenaar — Sat, 11 May 2013 08:01:31 GMT

See this blog post. It describes your problem almost literally. Change the field names to your fields and you should be good to go.

topic Re: currency conversion using peek in QlikView

currency conversion using peek

Re: currency conversion using peek