Skip to Content

how to hide a row in a table in webi

Hi All

I have a table that will display 7 rows dynamically now now my issue is one of the row has one column with "Null", Now I want to hide that row in preview.

How can I achive this in Webi.

Thanks in advance.

Siva

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jan 02, 2014 at 11:21 AM

    use a report level filter : [Column] Is not null

    If the value is Null(a string with "Null" value), the you can use the following filter: [Column] Not Equal to Null


    pastedImage_0.png (10.7 kB)
    pastedImage_0.png (11.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • 1. The filter, once saved, will be applied to all users viewing the report.

      2. You can apply such filter to a particular block or to entire tab.

      - To apply the filter to a particular block, select the block(click on any cell in the block) and then define the filter.

      - To apply the filter to entire tab, click on any white space inside the report and then define the filter.

      You can navigate to Map > Structure to see the report level filters and block level filters as a tree view. A report level filter will always be applied to all blocks inside the report while the scope of a block level filter is restricted to that block only.

      pastedImage_1.png (12.7 kB)
  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 01:36 PM

    Hi Siva,

    Two ways to apply filters in BO XI3.1. Have a look at this example in which I have a webi report based on e-fashion universe. I am extracting two columns: State(dimension) and Extended Price (Measure).

    Suppose that I would like to apply the filter on Extended Price to eliminate the null values:

    Fist way: Click on the icon: Show/Hide Filter Pane on the left, this area will be displayed:

    In this area drag and drop "Extended Price":

    The following window will be displayed: You should choose the operator "Is Not Null" then click on "OK"

    Second method:

    Click on "Edit Query" icon, a new window will be displayed in which you can applt your filter by dragging and dropping "Extended Price" in the Query filter area:

    Click on the arrow in front of the default operator displayed then choose "Is not null" among the operator list appearing then click on "Run Query":

    I hope that this is clear for you.

    Best regards,

    Wafa


    1.jpg (146.8 kB)
    2.jpg (140.7 kB)
    3.jpg (107.3 kB)
    4.jpg (180.7 kB)
    5.jpg (118.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 02, 2014 at 12:34 PM

    hi,

    plz find the screen shot,,


    aa.JPG (46.0 kB)
    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.