topic Create "simple" measure expression in QlikView

Create "simple" measure expression

imtiaz_ullah — Tue, 03 Feb 2015 12:56:37 GMT

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

Re: Create "simple" measure expression

Anonymous — Tue, 03 Feb 2015 13:00:58 GMT

Hi Immy,

Try something like this:

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

Regards,

Michael

Re: Create "simple" measure expression

imtiaz_ullah — Tue, 03 Feb 2015 13:24:32 GMT

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.

Re: Create "simple" measure expression

imtiaz_ullah — Tue, 03 Feb 2015 13:30:54 GMT

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

Re: Create "simple" measure expression

Anonymous — Tue, 03 Feb 2015 13:31:15 GMT

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

Re: Create "simple" measure expression

Anonymous — Tue, 03 Feb 2015 13:36:34 GMT

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.

Re: Create "simple" measure expression

imtiaz_ullah — Tue, 03 Feb 2015 14:58:09 GMT

Yes, the edited version worked perfectly. Thank you.