topic Re: How to hide & show specific dimension in chart in QlikView

How to hide & show specific dimension in chart

Naps_230 — Fri, 16 Mar 2018 11:21:25 GMT

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.

Re: How to hide & show specific dimension in chart

sumeet-vaidya — Fri, 16 Mar 2018 11:39:20 GMT

Hi jaso,

Please find attached qvw. Hope this solves your purpose.

Kindly use Enable Condition in Dimension.

Regards

Sumeet

Re: How to hide & show specific dimension in chart

Naps_230 — Fri, 16 Mar 2018 11:45:01 GMT

Hi Sumeet,

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

Thanks,

Jaso

Re: How to hide & show specific dimension in chart

katharinakostka — Fri, 16 Mar 2018 11:47:12 GMT

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

Re: How to hide & show specific dimension in chart

Naps_230 — Fri, 16 Mar 2018 12:06:15 GMT

Thanks katharina for posting

Re: How to hide & show specific dimension in chart

sumeet-vaidya — Fri, 16 Mar 2018 12:11:30 GMT

Hi,

I have attached the qvw again. PFA

Regards

Sumeet

Re: How to hide & show specific dimension in chart

katharinakostka — Fri, 16 Mar 2018 15:18:50 GMT

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.

Re: How to hide & show specific dimension in chart

Nagaraju_KCS — Fri, 16 Mar 2018 16:31:15 GMT

PFA,