Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Kindly help me in the below logic in the measure:
I have the below formula:
SUM(Total_Transfer)
I want the sum of only those whose Transfer date is maximum means MAX(Transfer_date).
Something like that:
SUM({$<Transfer_date = {MAX(Transfer_date)}>}Total_Transfer)..
But it is not working.
Thanks and Regards
Deepanshu
Sorry I cannot share the data or app due to some issue
I have attached the formula I am using in Qlik sense. Kindly check the formula
There are two upload dates : 2016-01-15 07:31:53 and 2016-01-21 10:15:07 with the Report_Type Filter M/W
I want the sum of only latest date for Report_Type W
Is the error because of the time format with date??
Kindly guide
What is
=Max(Uploaded_Date)
returning in a text box?
Maybe you need to use
$(=Date(Max({<Report_Type = {W}>} Uploaded_Date),'YYYY-MM-DD hh:mm:ss'))
Thanks a lot sir!!
I apply the above formula as:
Sum({$<Uploaded_Date = {"$(=Date(Max({<Report_Type = {M}>}Uploaded_Date), 'DD-MM-YYYY'))"}>}[Total Transfer])
It works!!
Thanks
Deepanshu
Hello Sir
I have attached my data set in form of tables
I use the below for formula:
Sum({$<Uploaded_Date = {"$(=Date(Max({<Report_Type = {M}>}Uploaded_Date), 'DD-MM-YYYY'))"}>}[Total Transfer]).
It takes the maximum upload date for Report_Type = M but somehow it takes the W also in consideration.
Can you please tell me where is the error
Please advice.
Thanks
Deepanshu
Try this:
Sum({$<Uploaded_Date = {"$(=Date(Max({<Report_Type = {M}>}Uploaded_Date), 'DD-MM-YYYY'))"}, Report_Type = {M}>}[Total Transfer])