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

[sunny_talwar]

May be this:

Sum({$<Transfer_date = {"$(=Date(Max(Transfer_date), 'YourDateFieldFormatHere'))"}>}Total_Transfer)

UPDATE: Max(Transfer_date) will return a number and to convert it to Date you will have to use Date function and also make sure that the formatting is also the same one as Transfer_date.

[swuehl]

Max Transfer_date in the TOTAL context, right?

SUM({$<Transfer_date = {$(=Date(MAX(Transfer_date),'MM/DD/YYYY'))}>} Total_Transfer)

format the max date as Date using Date() function and using an appropriate format code ('MM/DD/YYYY' is just an example).

[sunny_talwar]

Attaching a sample where I used a particular kind of formatting to display Transfer_date (MMMM DD, YYYY)

Script:

Table:

LOAD Date(MakeDate(2015, 1, 1) + Ceil(Rand() * 365), 'MMMM DD, YYYY') as Transfer_date,

  Ceil(Rand() * 1000000) as Total_Transfer

AutoGenerate 10000;

And then the expression I used:

Sum({$<Transfer_date = {"$(=Date(Max(Transfer_date), 'MMMM DD, YYYY'))"}>} Total_Transfer)

HTH

Best,

Sunny

[Anonymous]

Thanks a lot for your guidance!!

I am still getting error while using the formula. The date format is YYYY-MM-DD hh:mm:ss.

Attached is the snapshot of the formula I used.

Kindly help me!!

Regards

Deepanshu

[swuehl]

What error message do you get? Have you tried to just press ok and check the result in your chart?

[sunny_talwar]

Like Stefan said, I don't see where the error is? Are you seeing null or 0s?

[Anonymous]

I am getting 0 value

Thanks

Deepanshu

[Anonymous]

Yes!!.. I am working on Qlik sense.. On the below it shows OK.

But still I am getting 0 value...

Please guide

Thanks!!

Deepanshu

[sunny_talwar]

Would you be able to share a sample?