Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 -
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.
Try: Max(SaleId)
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.
Thank you very much...😀