Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sebbe1975
Contributor II
Contributor II

One to many Relationships

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                      -

1 Solution

Accepted Solutions
trdandamudi
Master II
Master II

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.

View solution in original post

3 Replies
vmoreno2605
Creator
Creator

Try: Max(SaleId)

trdandamudi
Master II
Master II

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
Contributor II
Contributor II
Author

Thank you very much...😀