Regarding Currency Conversion Factor

[neetu_singh]

Dear All,

I have a query. Actually, i have a sql table for "currency conversion factor". in this table conversion rate is against monthwise. when we extract this table in qlikview it will shows data related to jan & mar. Like:

Month Currency Rate

Jan USD 39.5

Mar USD 64.5

In this table "Feb" is missing. so in that case, when we select "Feb" then it will display the "Rate" Of "Jan" instead of "Null"

Plz rply me ASAP bcoz its urgent

Regards

Neetu Singh

[disqr_rm]

Is this what you are looking for?

[neetu_singh]

Thnks Rakesh

Bt when i select month from listbox it display null. Your answer is ok , i wnt this bt at the time of selection its not working. This is the problem

[disqr_rm]

In that case, you would need to build it in your script when loading data. Something like enclosed. Hope this helps.

[neetu_singh]

Hi

Thanks a lot, its work