Skip to Content

supress result in chart of VC

Hi Friends,

how can I supress the result in output chart.

For one BI Query I have an output table and an output chart.

In output table I have a result row, thats OK.

But in the chart it shows the result too, thats not OK.

How can I supress it only in the chart.

Thanks in advance.

RG. Jimbob

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 31, 2010 at 09:16 AM

    Hi,

    If you output the chart directly from the table, you could go through a filter (add a filter operator to the model and connect the table to the filter).

    In the filter you can exclude the result row (assuming you have a way to differenciate it from the other rows).

    From the filter you can output the chart in the same way you have done till now.

    Best regards,

    Tal.

    Add comment
    10|10000 characters needed characters exceeded

    • If the result row is part of the output table (for example, the last row in the output table) and it's an empty row (and the other rows have values) you can filter it like I suggested.

      If you want, you could supress it in the BI query and add an empty row to the table. For example, if you call the query by pressing a button, you could add another action to the button and add the row there (using the Insert action).