One to many Relationships

[sebbe1975]

Hello,

I'm new to Qlikview  and appreciate any help.
Is it possible to display the productID only with the highest SaleID in stright table? Now the productID is shown several times because it has been on several sales but I need to show only the one that have highest SaleID ( latest). Please also see the image.

ProductID                SaleID

A                                  10

A                                  5

A                                  2

B                                   5

B                                   1

C                                    1

D                                  Haven't been on sale yet ( empty)

I need this result:  

A                    10

B                     5

C                     1

D                      -

[vmoreno2605]

Try: Max(SaleId)

[trdandamudi · Accepted solution]

Once you created the table, create a straight table chart:

Dimension:

      ProductID

Expression:

    Max(SaleID)

You get the result that you want. Hope this helps.

[sebbe1975]

Thank you very much...😀