set analysis select data

Mon, 28 Sep 2015 14:12:25 GMT

Hi,

I've got a SQL query which is good. It is :

SELECT `annee`,`modif_date`,`idTypeDepense`,`idContratBene`,

`montant_ae`

FROM `previsionnel_depense`

WHERE `modif_date`<= "MYPARAM"

group by `annee`, `idTypeDepense`,`idContratBene`

ORDER BY `modif_date` DESC

It returns this datas :

My complete data is :

annnee	modif_date	idTypeDepense	idContratBene	montant_ae
2015	2015-09-01 00:00:00	1	2	15
2014	2015-01-01 00:00:00	2	31	42
2014	2014-09-01 00:00:00	1	2	10
2014	2014-07-07 00:00:00	2	31	44

My question is : how can I make this selection in qlickview when "MYPARAM" is modified in a calendar object?

thanks a lot for your responses.

topic set analysis select data in QlikView