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: 
siddharthsoam
Partner - Creator II
Partner - Creator II

Can we use the max function in load scipt in Qliksense

Hi ,

I want to use max function at backend to find the maximum report date coming from multiple bases.

Is it possible?

11 Replies
avinashelite

Ok but due you have the data mapping between the Fiscal Year /Month and the date because the above mapping is not dynamic more like an static approach ? if you define the logic between the Fiscal Year/Month and the date that will help us to get the desired output

Anonymous
Not applicable

Hi Siddharth,

Try using the below expression it is same as what you have already tried , just remove the second max

date(addmonths(Max(Date#(reportdate,'DD-MMM-YYYY')),-1),'DD-MMM-YYYY') as maxdate

your previous expressions would have yielded a the same result but in number instead of date if i am not wrong.


I hope this helps what you want to achieve.