Expression differences between Qlikview & Qliksense (#1)

[#1]

In Qlikview I could create a text box and enter the formula:  sum(if(data_dt = max(data_dt), sales)) to get the sum of sales for the max date.  When entering this formula in Qliksense I get an error, though don't know why.  Is there a different formula definition?  Is it ALL set analysis?

Thanks!   Dan

[sunny_talwar]

So if you do Num(DATA_DT) you see an integer and not something like 45169.1532564 kind of a number? Just want to make sure we are confident that DATA_DT is a date field and not timestamp.

[#3]

Yes...when I do Num(DATA_DT) I see 42369

[sunny_talwar]

Not sure what isn't working. Would you be able to share a sample?

[reddy-s]

Hi Dan,

Sounds Strange! The expressions should work the same in Qlikview and QlikSense. As Sunny Suggested, it would be easy if you share a QVF.

Thanks,

Sangram Reddy.

[#6]

I found a/the solution when looking through the documentation.  I'm not sure why my original formula worked in Qlikview but not Qliksense, but it needed a "Max" in there, as well as a "TOTAL"....

Sum(If(DATA_DT=Max(TOTAL DATA_DT), Sales))

This gives me the total sales, without a filter, for the max DATA_DT.  Thanks for all the help.