Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Set Anaysis Date Variable

I have this variable to allow the user to modify

Variable.JPG

I want to calculate with set analysis, sales from that date until today.

Easy no???

-sum({<"Posting Date" ={">=$(vFecha)"} Venta)

Maybe it's because of the format


Dosen't work

Please help



1 Reply
erich_shiino
Honored Contributor

Set Anaysis Date Variable

Hi,

Did you try to use this expression instead:

sum({<[Posting Date] ={">=$(vFecha)"} Venta)

There maybe another issue:

It's possible to make it work if you can guarantee that you can compare dates on the same format.

I suggest the use of fields and variables as numbers (as they are actually stored both on QV and Excel).

First, you need to create a field that you are sure will be only on a integer forma.t

So at the script level, where you create Posting Date create another one using num()

LOAD [Posting Date],

num ( [Posting Date] ) as nPostingDate,

other fields, etc

from ... // you regular script

Change your variable to

=num(today() -120)

Your final expression will be:

sum({<[Posting Date] ={'>=$(vFecha)'} Venta)

or

sum({<[Posting Date] ={'>=$(=vFecha)'} Venta)

Hope it helps,

Erich

Community Browser