Skip to Content

using contextual operator


(sorry for my english)

i've a problem with using an contextual operator (where) in webi report.

In the report, there several data source, all fusionned on the product code.

in one of data sources, i have the list of command for a product. A product can have 0, 1 or more commands on different dates.

I want to show the value of the command which is the first in date.

For exemple,

Product / command number / Date / quantity

Product 1 / Command 1 / 01/05/2018 / 100

Product 1 / Command 2 / 01/06/2018 / 200

in the report, i want to show only 100, and not 300 in quantity for the product 1.

I've tried :

quantity where (min(date) = date) but i always have 300.

How to do this so ?


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 13, 2018 at 09:23 AM

    create one variable Show/Hide=if(date=min(date) in (product) then "Show" else "Hide"

    Apply filter on Show/Hide variable where equal to Show to display one record.

    Add comment
    10|10000 characters needed characters exceeded