Skip to Content
0

how to filter out a line in webi

Sep 24, 2017 at 09:38 AM

33

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Sep 25, 2017 at 07:58 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Sep 24, 2017 at 09:53 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded