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?
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
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.
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.
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.
