How to hide & show specific dimension in chart

[Naps_230]

Hi Team,

I have one scenario. Please help on that

I have 3 buttons.

ex- Country, State, City

3 Dimensions & 1 measure

ex- Country,State,City  and  measure is Sales

Requirement:-

1. Country,State,City  are Dimension and  expression is Sales in Straight Table.

2.when i click on Country button , i want to show only Country, Sales in Straight Table.Other dimension are hide automatic.

3.when i click on State button , i want to show only State, Sales in Straight Table.Other dimension are hide automatic.

4.when i click on City button , i want to show only City, Sales in Straight Table.Other dimension are hide automatic.

[sumeet-vaidya]

Hi jaso,

Please find attached qvw. Hope this solves your purpose.

Kindly use Enable Condition in Dimension.

Regards

Sumeet

[Naps_230]

Hi Sumeet,

I am unable to find your qvw. Can you send again.

Thanks,

Jaso

[katharinakostka]

Hi,

there are several ways to archieve that.

I would add an action to the buttons setting a variable e.g. vButton you can set this value to 1 for country 2 for State and 3 for city (just an example).

Next step you go into the properties of the chart and add in dimensions tap a condition to the mentioned dimensions vButton=1 for the country dimension, vButton=2 fo State and so on.

you may add the same condition to the coloring of the button in order to archieve that the selected button is highlighted. (if you wish)

Or, less elegant, but also works: You take a container and put in three charts one for each dimension and call them State, Country, City you may switch the charts via buttons in a container... but this is the less elegant way as via variable&condition there's less ressources needed to calculate only one chart instead of three you have with the container.

Hope this helps.

Regards Katharina

[Naps_230]

Thanks katharina for posting

[sumeet-vaidya]

Hi,

I have attached the qvw again. PFA

Regards

Sumeet

[katharinakostka]

You're welcome, please tell me, if you need further assistance.

If your question was answered, please mark the most helpful answer as "correct answer", so others can see, that this request has been solved. Thank you very much.

[qv_testing]

PFA,