Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
eva_maria
Contributor III
Contributor III

How to mark a expression as invisible

Hi!

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

Regards

10 Replies
Not applicable

you can use ad-hoc report

marcus_sommer

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

Anonymous
Not applicable

something like that

MarcoWedel

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:

QlikCommunity_Thread_134168_Pic1.JPG.jpg

QlikCommunity_Thread_134168_Pic2.JPG.jpg

QlikCommunity_Thread_134168_Pic3.JPG.jpg

QlikCommunity_Thread_134168_Pic4.JPG.jpg

hope this helps

regards

Marco

eva_maria
Contributor III
Contributor III
Author


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

Regards

eva_maria
Contributor III
Contributor III
Author


Hi Marco!

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

regards

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

Peter

MarcoWedel

Hi,

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

QlikCommunity_Thread_134168_Pic2.JPG.jpg

QlikCommunity_Thread_134168_Pic3.JPG.jpg

QlikCommunity_Thread_134168_Pic4.JPG.jpg

hope this helps

regards

Marco

eva_maria
Contributor III
Contributor III
Author

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