topic Re: Using Today() in set analysis in QlikView

Using Today() in set analysis

johnmccdwc — Wed, 22 Jun 2016 14:04:39 GMT

I want to show a running total for 'Today' in a model.

The following works (when i hard code the date)

=sum({$<CurYTDFlag = {1},LineType = {2},ShipDate={'22/06/2016'}>} NetDelQty)

but when i try to use Today i cannot get it to fly:

=sum({$<CurYTDFlag = {1},LineType = {2},ShipDate={$(=Date(today(),'DD/MM/YYYY'))}>} NetDelQty)

ANy ideas?

John

Re: Using Today() in set analysis

andrespa — Wed, 22 Jun 2016 16:16:35 GMT

Hi John, did you try to put it into a variable and the put the variable in the set analysis?

Hope it helps,

Andrés

Re: Using Today() in set analysis

swuehl — Wed, 22 Jun 2016 16:23:50 GMT

Where are you using this expression? In a chart?

Then put it into e.g. a straight table chart's expression and leave the expression label empty.

Then hover with the mouse over the expression header in the table chart.

You should see your expression with the dollar sign expansion evaluated and replaced.

What do you see?

I can only think of two possible differences right now between the two expressions:

a) Missing single quotes in the second expression around the dollar sign expansion:

=sum({$<CurYTDFlag = {1},LineType = {2},ShipDate={'$(=Date(today(),'DD/MM/YYYY'))'}>} NetDelQty)

b) today() may not return '22/06/2016', because the default timer mode is returning the date when your QVW was opened.

See the help for available timer modes (0 to 2).

=sum({$<CurYTDFlag = {1},LineType = {2},ShipDate={'$(=Date(today(1),'DD/MM/YYYY'))'}>} NetDelQty)

Re: Using Today() in set analysis

sunny_talwar — Thu, 23 Jun 2016 04:50:20 GMT

Can you try this (added double quotes in red)

=Sum({$<CurYTDFlag = {1}, LineType = {2}, ShipDate = {"$(=Date(Today(), 'DD/MM/YYYY'))"}>} NetDelQty)

Re: Using Today() in set analysis

johnmccdwc — Thu, 23 Jun 2016 10:06:04 GMT

Thanks Sunny, this worked

JOhn

Re: Using Today() in set analysis

johnmccdwc — Thu, 23 Jun 2016 10:07:02 GMT

HI Stefan

interestingly this seems to work but the Syntax checker doesn't like it

thanks for the reply.

JOhn

Re: Using Today() in set analysis

swuehl — Thu, 23 Jun 2016 13:13:26 GMT

Right, the syntax checker is not really able to understand that the dollar sign expansion is actually evaluated and replaced before the expression is parsed. So it might indicate an error here.

I still prefer to use single quotes for literals and double quotes for searches, though both should work the same in current QV software (there is a note by HIC in one of his blog posts that these quotings should be handled differently, but apparently they won't fix it (and this will break a lot of people's stuff)).

Regards,

Stefan