Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
hildacgg
Creator
Creator

How can I get the last sales date for each product in the script?

I need to upload only the last day when the product was sold, please help!

1 Reply
kaushiknsolanki

Hi,

You can use the max function.

Load Product,Max(SoldDate) as LastSoldDate

From xyx

Group by Product;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".