Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is this what you are looking for?
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
In that case, you would need to build it in your script when loading data. Something like enclosed. Hope this helps.
Hi
Thanks a lot, its work