Execute a Sql from presentation qvw

Thu, 04 Apr 2013 05:09:00 GMT

i have 3 documents in the aplication architecture

Extraction

Model

Presentation

in the extraction qvw i make a sql in the data base and store it in a qvd file

then i load it and transform it in the model qvw.

and in the presentation qvw show some data (expresions calculations charts)

this sql is executing with a date parameter Today.

but now in the presentation qvw i have a calendar table

and i need

if i select a date in this calendar filters make the sql extraction not with the parameter today

make sql from presentation with this selected date

transform it in the model qvw

and show the same data (expresions calculations charts) but of the selection i made.

how i can do this.....

topic Execute a Sql from presentation qvw in QlikView