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

Button that changes settings of table

Hello,

I haven't worked yet with buttons and was wondering if this was possible:

I have a Table A that suppresses when the value of dimensions Y and Z is Null. Now I want to create that gives the user the option to show also these lines.

So I need to know a command that changes this settings but I have no idea which one I should use.

Can someone help me here?

Thanks,

Steven

1 Reply
Not applicable
Author

No one has an idea? I looked through the forum and sofar I got this but its not (yet) working (I actually know nothing about VBA but think thats the only way to make this work)...

function NullSuppression

    set chart = ActiveDocument.getSheetObject("Matrix")

    set chartProperties = chart.GetProperties

    set dims = chartProperties.Dimensions

    dims(0).NullSuppression = True

    chart.SetProperties chartProperties

End function