topic Re: Conditionally show a chart on the same sheet in QlikView

Conditionally show a chart on the same sheet

Darumaka — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I have nine charts on one sheet. Additionally I have nine other charts that I want to show on the same sheet. But I want to be able to toggle between these two "views". How do I achieve this?

I hoped to find the answer in the continuos classroom or a guide somewhere without success. Do you know if it is explained somewhere or can someone here help me?

Thanks in advance!

Re: Conditionally show a chart on the same sheet

MindaugasBacius — Mon, 22 Jun 2020 11:46:10 GMT

Create a new dimension like:

Switching:
LOAD * INLINE [
_Switching
First
Second
];

Then simply on each of the chart use Properties > Layout > Show regarding of your needs:

=Switching='First'

=Switching='Second'

Create new listbox with the Switching dimension.

For more control use Sheet properties. For example automatically selecting First when opening the sheet.

Re: Conditionally show a chart on the same sheet

Darumaka — Mon, 22 Jun 2020 12:16:41 GMT

Thank you! That seems to be working. I will just need to check out a few more things before accepting as a solution.

Just one tiny question, in the Load statement you write _switching with an underscore but then you reference it without underscore. I assume that it was just a mistake. But the question is if it is preferred that dimension variables start with an underscore, so that it is suggested in the naming what they are used for?

Re: Conditionally show a chart on the same sheet

Brett_Bleess — Wed, 08 Jul 2020 19:14:38 GMT

I believe that was a typo! 🙂 You can name things pretty much anyway you see fit but most folks do use a 'v' in the name of variables etc., they tend to follow general dev practices when doing development in QlikView too. Here are a couple of links that may be of some help to you overall:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/LoadData/best-practices-data-modeling.htm

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/application-performance-optimization.htm

Those may provide some tips to help longer term. If you are all set, do not forget to return to close out the thread.

I did find a couple of Design Blog posts too:

https://community.qlik.com/t5/Qlik-Design-Blog/Enhancing-the-User-Experience-Using-Conditional-Expressions/ba-p/1472583

https://community.qlik.com/t5/Qlik-Design-Blog/Enhancing-the-User-Experience-Using-Conditional-Expressions-Part/ba-p/1463327

Regards,
Brett

Re: Conditionally show a chart on the same sheet

Darumaka — Tue, 14 Jul 2020 07:08:49 GMT

Great, thank you so much, I will look into the links you posted.

I have one more question. You write that I can automatically selecting one of the views when opening the sheet in the sheet properties. How do I achieve this?