topic How to mark a expression as invisible in QlikView

How to mark a expression as invisible

eva_maria — Fri, 19 Sep 2014 17:14:28 GMT

Hi!

Is there any way (macro, button....)to mark an expression as invisible without having to enter the graph properties?

Regards

Re: How to mark a expression as invisible

Fri, 19 Sep 2014 17:17:02 GMT

you can use ad-hoc report

Re: How to mark a expression as invisible

marcus_sommer — Fri, 19 Sep 2014 17:57:58 GMT

Dimensions and Expressions could have a condition which could be certain selections or certain users or a variable-value which could be changed per inputbox or a button.

- Marcus

Re: How to mark a expression as invisible

Anonymous — Sat, 20 Sep 2014 19:14:48 GMT

something like that

Re: How to mark a expression as invisible

MarcoWedel — Sat, 20 Sep 2014 22:23:14 GMT

Hi,

there is no need for macros to enable/disable an expression.

Instead you can toggle a variable that conditionally enables an expression using a button like this:

hope this helps

regards

Marco

Re: How to mark a expression as invisible

eva_maria — Tue, 30 Sep 2014 07:34:46 GMT

Ok! that's works fine for pivot and simple charts, but i cannot use yoru solution in a bar chart.

Regards

Re: How to mark a expression as invisible

eva_maria — Tue, 30 Sep 2014 07:35:57 GMT

Hi Marco!

Thanks for your reply, but i can't do your solution works in a bar chart.

regards

Re: How to mark a expression as invisible

Peter_Cammaert — Tue, 30 Sep 2014 08:36:08 GMT

Why not? Change Marco's table into a bar chart (Proprties->General tab) and the buttons will behave exactly the same as before.

Peter

Re: Re: How to mark a expression as invisible

MarcoWedel — Tue, 30 Sep 2014 10:13:22 GMT

Hi,

how did you try it? I don't see issues with bar charts:

hope this helps

regards

Marco

Re: Re: Re: How to mark a expression as invisible

eva_maria — Tue, 07 Oct 2014 18:36:42 GMT

Hi Marco!

Thanks for your reply and your sample file, but it doesn't work when i open the file in my qlikview (version 9.00)

following your instructions i have changed your table in a bar chart, and the tabs in the properties menu, and as you can see in the attached files, i don't have the options to do a expression works condiionally.

File simple_chart shows the properties tab where i can do a expression works conditionally

file bar_chart shows that there is no option to do a expresion works conditionally

file marco shows what i have when open your second sample file

Thanks for your help and time.

regards

Re: How to mark a expression as invisible

MarcoWedel — Tue, 07 Oct 2014 19:57:50 GMT

do you have the possibility to upgrade to a newer QlikView version ?

regards

Marco