Discussion Board for collaboration related to Creating Analytics for QlikView.
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:
How should i do this?
Thanks a lot!
Go to Solution.
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).