Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm new to qlikview and i'm having trouble using firstsortedvalue.
This is what i'm working on:
i would like to know the product that each customer bought in the first place.
So what i would like to see is:
CUSTOMER | PRODUCT |
---|---|
CUSTOMER 1 | PRODUCT 1 |
CUSTOMER 2 | PRODUCT 1 |
COSTOMER 3 | PRODUCT 2 |
How should i do this?
Thanks a lot!
Create a chart with dimension CUSTOMER and as expression
=FirstSortedValue(PRODUCT, [BUYING DATE])
take care that buying date field has a numeric representation (i.e. is interpreted as date by QV).
Create a chart with dimension CUSTOMER and as expression
=FirstSortedValue(PRODUCT, [BUYING DATE])
take care that buying date field has a numeric representation (i.e. is interpreted as date by QV).