Discussion board where members can get started with QlikView.
Hi, i am trying to display the first and last transaction per till per customer per day.
My fields are :
transId (Transaction Id)
TransStartDate (Transaction Date)
Can anyone help please?
Have a look at the firstsortedvalue() function. This may help you to achieve you requirement.
Try to make a calculated dimension ....
- it might be slow -
load StoreNumber,min(TransStartDate),max(TransStartDate) resident table1
group by StoreNumber;
Try this method .