Discussion Board for collaboration related to Creating Analytics for QlikView.
Hi i am trying to do a sum of a field without a dimension
My data looks like this:
I want to get the first ordervalue recorded for each customerid and compare it to the most recent ordervalue for that same customer and see if it is greater, if it is i want to count it.
I can then show "95 orders placed that are greater than first order value" in a text object rather than a chart.
How do i do this? Aggr? FirstSortedValue?
Go to Solution.
Yes, you could use Aggr() with FirstSortedValue(). See attached QVW that uses the following expression:
=Sum(Aggr(If(FirstSortedValue(OrderValue,-TranscactionID,1) > FirstSortedValue(OrderValue,TranscactionID,1),1,0),CustomerID)) & ' orders placed that are greater than the first order value'
Hope this helps,
Jason Michaelides that is great - thank you
yes do what jason told to u it is correct i think