Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
hopkinsc
Valued Contributor II

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
Contributor III

displaying the first and last transaction per customer

Hi,

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

-Sridhar

klausskalts
Contributor

displaying the first and last transaction per customer

Try to make a calculated dimension ....

- it might be slow -

perumal_41
Valued Contributor II

displaying the first and last transaction per customer

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

Community Browser