How to set the field in a cyclic group

[#1]

Hi,

I have create a cyclic Group CurrencyGroup:

CurrencyLocal

CurrencyUSD

CurrencyEUR

and I use CurrencyGroup in all my reports.

I'd like to create a Button that selects the respective currency (Local, EUR, USD). How can I change the field used in the cyclic group via a button?

If possible a solution to be used without a macro.

Kind Regards,

Dion

Sr. BI Consultant.

[#2]

Hello

Create variables VarLocal, VarUSD, VarEuro to 0, from the button you have to give value 1 to enable the variable within the typical expression IF (VarLocar = 1, sum (CurrencyLocal), IF (VarUSD = 1, sum (CurrencyUSD) ,IF (VarVarEuro = 1, sum (CurrencyEUR))))

I hope the answer is useful

[erichshiino]

Hi,

Please, check if this post can help you:

http://community.qlik.com/message/126621#126621

Another option it the creation of a kind of 'dynamic' dimension:

- instead of a grouped dimension, you can write a dimension like this:

=Currency$(varCurrency)

When the user select a value for varCurrency (input box with options in a combo) the dimension name will be updated in all the charts with this dimension

Hope this helps,

Erich

[jagan]

Hi,

Check this posts, there is a solution for your requirement

http://community.qlik.com/message/48825#48825

http://community.qlik.com/message/87251#87251

Hope this helps you.

Regards,

Jagan.