Skip to Content
avatar image
Former Member

how to filter out a line in webi

Hi

I have a question on a filter set

If the table have 2 version of a PO number, and I just want to show only the most recently record, what is a good way to do it

I tried to you rank function but it always show at 1 for each of record because the table recognize each of PO number as a distinctive value even though the PO number look like same (2959 for example)

Thank you

capture.png (15.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 25, 2017 at 07:58 AM

    Hi,

    you need to capture in a variable: Max Version: something like

    v_Max_Version= =Max([Version]) In ([N° PO])

    then create a new variable:

    v_filter= if [Version]=[v_max_Version] Then 1 else 0

    add v_filter to your table and create filter on it, v_filter=1

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 24, 2017 at 09:53 AM

    Is there any more object in the table for which values are different.in your screenshot all values are same for one PO number.how do you know which is latest value for PO?

    Use Desending function in your rank variable to get latest values from bottom.

    Add comment
    10|10000 characters needed characters exceeded