Create "simple" measure expression

[imtiaz_ullah]

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

[Anonymous]

Hi Immy,

Try something like this:

sum({<Date={">=date(today())"}>} quantity)

Regards,

Michael

[imtiaz_ullah]

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.

[imtiaz_ullah]

Here is a snippet - any idea why QS would red underline? I am using that field happily in other areas... Thanks

[Anonymous · Accepted solution]

OK, let's change a little:
sum({<Date={"$(='>=' & date(today()))"}>} quantity)

[Anonymous]

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.

[imtiaz_ullah]

Yes, the edited version worked perfectly. Thank you.