topic Re: set analysis operators in QlikView

set analysis operators

grajmca_sgp123 — Thu, 30 Jul 2015 08:07:04 GMT

Hi,

I have requirement where i need to convert local currency to USD amount.

sum((Sales*ExgRate)/ZFFACT)---this expression will converts to USD sales Amount.

Now I want to divide this amount by current week,Previous week and QTD wise.

I have used below set expression to calculate Current week sales ,looks I have mistake in expression.

sum({<FW = {'$(vCurrentWeek)'}>} Sales* ExgRate)/ZFFACT

kindly let me know your inputs how we can achieve this,is there any other ways to do this logic??

Gysbert_Wassenaar — Thu, 30 Jul 2015 08:11:02 GMT

Can you post a qlikview document that demonstrates the problem?

qlikviewwizard — Thu, 30 Jul 2015 08:18:15 GMT

Can you attach the sample file with the data?

tresB — Thu, 30 Jul 2015 10:20:53 GMT

May be like:

=Num(sum({<FW = {'$(vCurrentWeek)'},[Fiscal Year] = ,Quarter = ,Month =>} fabs((Value)*ExgRate)/ZFFACT) /1000000,'$#,##0.00 M') // for current week

settu_periasamy — Thu, 30 Jul 2015 14:06:17 GMT

if you want to convert, you need put the currency code also.

for Current week value

sum({<FW = {$(vCurrentWeek)}>} Value)* Only({<CurrencyCode={'USD'}>}ExgRate)

for previous

sum({<FW = {$(=(vCurrentWeek)-1)}>} Value)* Only({<CurrencyCode={'USD'}>}ExgRate)

qlikviewwizard — Fri, 31 Jul 2015 13:48:41 GMT

Hi,

Did you get the solution? Please let us know. Thank you.