topic Re: Problem with currency selection in QlikView

Problem with currency selection

Thu, 30 Aug 2012 14:06:06 GMT

Hi all,

I'm new to Qlickview so my problem will probably easy to solve.

I have the following problem:

I have multiple companies with their own currency (in my case EUR and GBP).

Their is a list box where i can select the 'Original' currency or 'EUR' currency.

How does my expresssion need to be so when no company is selected, the EUR currency is applicable, and when a company is selected, the original currency is applicable?

Thanks for the help.

Sebastien.

Re: Problem with currency selection

Thu, 30 Aug 2012 14:27:01 GMT

Since it is a bit difficult to fully expain in text, I made an example qvw.

The resulting expression is:

EURprice * if(GetSelectedCount([currency-code])=1,factor,only({<IsdefaultCurrency={1}>}factor))

What it does is this: when no currency is selected, the only() function is used with setanalysis that makes sure that only the default currency will be selected.

See the attached example. I hope this is (similar to) what you are looking for

Re: Problem with currency selection

Thu, 30 Aug 2012 15:22:43 GMT

Roberto,

I'm not sure this is what i'm looking for.

When i open the file (dashboard), it is put on 'Original' currency as default.

Let's say i want to see the overall sales in Euros, I select 'Euro' but because one of the company's is in GBP my group result isn't totally correct because it adds Euros with Pounds.

It would be nice if no company is selected, Qlickview automatically takes 'EUR' currency because here the pounds are already converted to Euros.

Thanks anyway for the effort.

Re: Problem with currency selection

lucas4bi — Fri, 31 Aug 2012 09:18:41 GMT

Hello, can you make an example of how the table is made?

Re: Problem with currency selection

Fri, 31 Aug 2012 10:24:20 GMT

Could you give some more details about which columns / expressions you use?

A (small) example app would be ideal. There is no need for "real data", as long as your qvw has "the same problem / logic".

I still think that the function GetSelectedCount() is helpful for you, or perhaps the function =GetFieldSelections() (which returns what value you have selected). This in combination with an if/else or sum(if() ) shouild do the trick...

Hope it helps. If not, hope you can provide an example qvw.

Re: Problem with currency selection

Tue, 04 Sep 2012 12:13:15 GMT

Ok, i think i was able to solve it with your function. I didn't understand it completely the first time.

Thanks!

Re: Problem with currency selection

Tue, 04 Sep 2012 12:14:38 GMT

"I think"....

In case you still have any doubt, please let me know. I'd be happy to explain things a bit further when it isn't clear yet. In that case, let me know what the current unclarities are.