Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
neetu_singh
Partner - Creator III
Partner - Creator III

Regarding Currency Conversion Factor

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

4 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

Is this what you are looking for?

neetu_singh
Partner - Creator III
Partner - Creator III
Author

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
Partner - Specialist III
Partner - Specialist III

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

neetu_singh
Partner - Creator III
Partner - Creator III
Author

Hi

Thanks a lot, its work