Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Goodafternoon to all,
I am trying work out what the totaal sales is on the highest datum, or otherwise max(date). Sum({$<Date={'31-5-2014'}>}sales) gives a return. I should probably add that i cannot change the script, its locked down(long story). I can only do something with the expression, so can someone please help me out by explaining how i can change the aforementioned expression to work out the max(date). Thanks in advance.
Mo
Try this please
sum({$<Date={"$(=Max(Date))"}>} Sales)
also
you can unlock your code by click unlock icon on the right top corner
Try this please
sum({$<Date={"$(=Max(Date))"}>} Sales)
also
you can unlock your code by click unlock icon on the right top corner
Try this:
Sum({$<Date={"$(=Date(Max(Date), 'D-M-YYYY'))"}>}sales)
Thats great, it works.and if i want to do max(date) minus 1.
The guys have suggested you right, just check if it works properly.
To unlock the field look for this icon:
I am using Qlik Sense , the unlock button is on the top right
May be this:
Sum({$<Date={"$(=Date(Max(Date) - 1, 'D-M-YYYY'))"}>}sales)