Filter in visualization

[Anonymous]

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

[Anonymous]

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

[swuehl · Accepted solution]

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'))

[Anonymous]

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

[Anonymous]

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.

swuehl‌

sunindia‌

gwassenaar‌

Thanks

Deepanshu

[sunny_talwar]

Try this:

Sum({$<Uploaded_Date = {"$(=Date(Max({<Report_Type = {M}>}Uploaded_Date), 'DD-MM-YYYY'))"}, Report_Type = {M}>}[Total Transfer])