topic Re: Set analysis with date = today() - 1 in QlikView

Set analysis with date = today() - 1

Wed, 25 Feb 2015 14:26:39 GMT

Hi everybody

I have the field DATE and the field MONEY

i wanna sum(MONEY) in date = today ()-1 (the day before the current day)

how i do this ? i've been trying a few options but they didn't work.

Greetings.

Re: Set analysis with date = today() - 1

datanibbler — Wed, 25 Feb 2015 14:30:15 GMT

Hi Jeremias,

do you want just the value of yesterday or the sum of all values up until yesterday?

The set_expression for it would be

>>> sum({$<[date] = {"$(= '<=' & Today())"}>} MONEY)

There is in principle a more elegant solution, you can use the parameter "-=" in set_analysis - but then the script_editor doesn't recognize it and will mark all the following code as wrong regardless of whether or not it is correct.

HTH

Best regards,

DataNibbler

Re: Set analysis with date = today() - 1

MK_QSL — Wed, 25 Feb 2015 14:32:38 GMT

SUM({<Date = {'$(=Date(Today()-1))'}>}MONEY)

Re: Set analysis with date = today() - 1

jonathandienst — Wed, 25 Feb 2015 14:36:01 GMT

If you are doing this in a text box, then something like:

Sum({<DATE = {'$(=Date(Today() - 1))'} MONEY)

This assumes:

DATE is formatted in the default format for your environmment
DATE has no time component

HTH

Jonathan

Re: Set analysis with date = today() - 1

Oleg_Troyansky — Wed, 25 Feb 2015 14:39:52 GMT

Or, to eliminate the formatting issues, you can use advanced search:

Sum({<DATE = {"=DATE=$(=Today() - 1)"} MONEY)

cheers,

Oleg Troyansky

masterssummit.com - take your QlikView skills to the next level!

Re: Set analysis with date = today() - 1

Wed, 25 Feb 2015 14:51:34 GMT

Thank you. Everybody said that i should use this expression but it isn't working and i don't know why.

DATE is the field and Date is a function?

thank you

Re: Set analysis with date = today() - 1

Oleg_Troyansky — Wed, 25 Feb 2015 14:55:33 GMT

Post a sample app, and we will show you why it's not working and how to fix it.

Date can be both a field and a function, no problem there.