Switching fieldnames in Charts with a Variable

[christoph_suess]

Dear all,

in one of my applications I have implemented a second calendar besides the normal one that follows the 4-4-5 concept. Now I implemented a button to switch from one calendar to another fast within my dashboards. As I have different calendar fields I imported their switch variable with an excel file. The line for every calendar field goes like this:

vMonthYear

If(vCalendarChoice=1,[Month Year],[Month Year 2])

So I linked the button that should switch my calendar view with vCalendarChoice. Instead of the field Month Year with a calculation I now insert the Variable vMonthYear into the chart to switch the Field used by clicking on my switch button. The text in my excel file is exactly as shown above. Two things are not clear for me: is the way I import If(vCalendarChoice=1,[Month Year],[Month Year 2]) right or do I need to use an equals or quotes? How do I use the variable correctly with a chart expression?

Thank you for your help!

[krishna_2644]

Can you please post your qvw?it would be better for understanding on what you are trying to do.

Thanks

[swuehl]

I think it depends on how you insert your variable in your chart dimensions / expressions, i.e. with or without dollar sign expansion:

The Magic of Variables