QlikView App Dev

[#1]

Good day,

I have a problem with the current date, and need to make a daily count of the previous to the current date manualmete this without editing the current date , then in this case I works like this:

= Count ( { < [ Effective Date Quote ] = {' > = 03.20.2015 ' } >} Sales )

but I need evaluate the Today () within the función.en instead of : ' > = 20.03.2015 '

Thank you very much for your attention stay tuned ...

[jaimeaguilar · Accepted solution]

Hi,

you can do something like this:

= Count ( { < [ Effective Date Quote ] = {"$(=date(today(), 'DD.MM.YYYY')) " } >} Sales)

just for you to notice, if your default date format is set to 'DD.MM.YYYY', then you don't need to specify the format within set analysis, this is just in case (the default date/time format can be set in the first script tabs where all the environment variables are declared).

Also take care of the use of single and double quotes. In this example i'm using double quotes for enclosing the expression and single quotes for setting the date format in case you need to set it.

regards

[#3]

Yeah thks for your time!!!!!!