Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

displaying the first and last transaction per customer

Hi, i am trying to display the first and last transaction per till per customer per day.

My fields are :

StoreNumber (Customer)

TillNo (Till)

transId (Transaction Id)

TransStartDate (Transaction Date)

Can anyone help please?

3 Replies
sridhar240784
Creator III
Creator III

Hi,

Have a look at the firstsortedvalue() function. This may help you to achieve you requirement.

-Sridhar

klausskalts
Partner - Creator
Partner - Creator

Try to make a calculated dimension ....

- it might be slow -

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

table1:

Load

StoreNumber (Customer)

TillNo (Till)

transId (Transaction Id)

TransStartDate (Transaction Date)

from table

join

load StoreNumber,min(TransStartDate),max(TransStartDate) resident table1

group by StoreNumber;

Try this method .

Regards ,

Perumal.A