Skip to Content
author's profile photo Former Member
Former Member

A control to show/hide an element - Webi 4.1 SP5


I want to hide or show a table and I need to do it with a button, or any other "on-off" control.

I dont want to create any new table at the DB with a boolean value field (or just an integer with "0" and "1" value) and then I can add at the filters pannel a new dimension refering to that table field.

I can use the filter panel, it will be Ok. But I cannot figure out how to do it, like If I was developing a dashboard and add a control as a switch to hide a table.

I appreciate any kind of help.

Thanx in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Mar 24, 2015 at 07:30 AM


    this document can help you

    Dynamic Visibility within a Webi Report

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you Saurab,

      thats the way I've already done it. I've seen your reply late. After, post this message, the day after, with my mind fresher it worked.

      I really wanted to add a control at the report but filter panel is nice solution. I hope the client liked the proposal.

      THANKS anyway.

  • Posted on Mar 24, 2015 at 07:00 AM

    Hi ,

    You can do it with the help of Input controls. Please follow below steps

    1. Create a variable with formula as = ""

    2. Add this to the table that you want to hide/show as a column

    3. Create a new input control with entry field. It should be free text box.

    4. Go to the table and right click and navigate to hide when .. and type the formula in the hide when box as formula [new variable] = 1 or "Show".

    5. Now type your text either 1 or Show in the free text input control and hit enter to toggle the table.

    Hope this helps.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.