Discussion Board for collaboration on QlikView Scripting.
I have a requirement where I need to multiply the standard cost * exchrate(exch value should be based on max date),how should we achieve it in script level.
Output looks like
Go to Solution.
[Currency Standard Cost]:
(ooxml, embedded labels, table is [Currency Standard Cost]);
max(Date) as maxDate
(ooxml, embedded labels, table is [Exchange Rate])
group by Currency,
[Max Date Exchange Rate]:
Date Resident [Exchange Rate] where Date=maxDate;
Drop Table [Exchange Rate];
Please find the solution in attachment
Thank you Ashraf,
I am using personal QV edition so can you please paste the script once.
Thank you so much Ashraf....I will check the solution and mark it.
Hi Swathi is above solution resolved your problem or not. If your problem is solved then pleased marked it as Correct