Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

michielvandegoo
Valued Contributor

Set analysis, Sum({1} Sales/$(vExchangerate)), {1} doesn't work

Hi,

I have this statement:

=Sum ({1}Sales)/$(vExchangeRate)

I expect this would return sales for all years (2005 - 2009) but it only returns sales for selected year.

I also tried

=Sum ({1}Sales/$(vExchangeRate))

but this also returns only sales for selected year.

Is my assumption correct that it should return all years?

If not, should I create a date island?

Thanks

Tags (1)
4 Replies
Not applicable

Re: Set analysis, Sum({1} Sales/$(vExchangerate)), {1} doesn't work

Hi,

but what is there in $(vExchangeRate)?

An expression? do you use  {1} in that?

C u,

Stefano

michielvandegoo
Valued Contributor

Set analysis, Sum({1} Sales/$(vExchangerate)), {1} doesn't work

Fixed number depending on currency selection . Each currency has 1 fixed exchange rate.

Not applicable

Set analysis, Sum({1} Sales/$(vExchangerate)), {1} doesn't work

If  in the expression inside variable you don't use {1}, you divede Sum({1} Sales) for only exchange rate of the year selected.

is i tpossible?

Stefano.

michielvandegoo
Valued Contributor

Set analysis, Sum({1} Sales/$(vExchangerate)), {1} doesn't work

If I understand your remark, yes, that's correct.