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

finding the latest date where sales exist for all customers (in script)

Hi all,

i need to update a variable in the script that holds the latest date where sales exist for all customers.

basically, i load in data for all of the customers, some customers are quicker at supplying data than others, i only want to report on the latest date where i have received data for everyone. i need to get this done in the script then once i have found the latest date i need to store the date in a variable. i then want to use the variable later in the script to create some flags against dates.

I am looking for help to get the script written to find the latest date first.

can anyone help please?

i have attached a sample and included a sample excel file with 2 customers in it.

the excel file has data for Cust A that goes from 04/01/2016-27/11/2016 and data for Cust B from 04/01/2016- 09/10/2017.

so the resulting variable should state 09/10/2017 as this is the last date that data has been received for both customers.

can anyone help please?

Thanks in advance

11 Replies
sunny_talwar

Where exactly is the new sample? Don't think I see it? Also, not sure I understand this

i have tried using Sunny's suggestion and am,ended it slightly to work out the no.of customers instead of hard coding.

You tried my suggestion and then what happened? Can you may be explain a little more?

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

apologies, i found a problem with the data, your suggestion now works

thanks, i changed your example to work out the count of distinct customers instead of hard coding.

thanks all for your help