Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trialling QlikSense and am trying to create a measure which is filtered based on date.
I have a date and quantity field being returned in my dataset.
All I want to do it calculate the sum of quantity where the date is greater than today.
I can easily do this at the DB level, but would prefer to calculate it in QS.
Thanks
Immy
OK, let's change a little:
sum({<Date={"$(='>=' & date(today()))"}>} quantity)
Hi Immy,
Try something like this:
sum({<Date={">=date(today())"}>} quantity)
Regards,
Michael
Hi Michael – almost…
It doesn’t error on the syntax now but returns 0. I know have data which is greater than today ☺
Your help is appreciated.
Here is a snippet - any idea why QS would red underline? I am using that field happily in other areas... Thanks
OK, let's change a little:
sum({<Date={"$(='>=' & date(today()))"}>} quantity)
Well, it says that the field doesn't exist... Check the spelling. On the other hand, the "syntax checker" sometimes is wrong and the expressions with red lines sometimes work. Check my latest expression, see if it helps.
Yes, the edited version worked perfectly. Thank you.