topic Re: Re: currency change in QlikView

currency change

Wed, 24 Sep 2014 09:53:33 GMT

Dear All,

I have 2 table as in attachment..1st having transaction data and in which value is in INR.. and

In 2nd table date wise $ rates are given... as

from >=1/1/2014 to <2/1/2014 rate is 56...then

from >=2/1/2014 to <2/25/2014 rate is 61..then

from >=2/25/2015 to <7/13/2014 rate is 60..and so on as in attachment..

and i have to create a table having column of Value (S) as per dates..

Value of $ = Value(INR) / $ Rate

Please tell me the solutions...

Rahul

maxgro — Wed, 24 Sep 2014 10:15:27 GMT

see attachment

Wed, 24 Sep 2014 11:28:38 GMT

Thanks for example massimo...but is there are any other option which can be used in the front end only..in dimension or expression tab??

maxgro — Wed, 24 Sep 2014 12:19:43 GMT

not completely, see another attachment, now the script is very simple

Wed, 24 Sep 2014 12:30:26 GMT

thanks massimo...

can u plz describe "date(alt(peek(Date2)-1,makedate(2099)))"...

maxgro — Wed, 24 Sep 2014 13:11:47 GMT

Date2, Date3

01/02/2014

25/02/2014

17/10/2014

I want in Date3=end of date range the start (Date2) of next row - 1

So I read Date2 in descending order and with peek (Date2 previous row) -1 set Date3; peek(Date2)-1

Date2, Date3

01/02/2014 24/02/2014

25/02/2014 16/10/2014

17/10/2014

Last Date3 is missing

I use alt to replace the missing with a big date makedate(2099); it could be makedate(3000), makedate(2100,12,31)..

makedate(2099) --> 01/01/2099

alt(null(), makedate(2099)) --> 72686 (number of 01/01/2099, alt get the first number)

date(alt(null(), makedate(2099))) --> 01/01/2099

date(alt(peek(Date2)-1,makedate(2099))) as Date3,

when there is a previous row I get the Date2 of previous row, else 01/01/2099