Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis select data

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 :

annee modif_date Décroissant  idTypeDepense idContratBene montant_ae
20152015-09-01 00:00:001215
20142015-01-01 00:00:0023142
20142014-09-01 00:00:001210

My complete data is :

annneemodif_dateidTypeDepense idContratBene montant_ae
20152015-09-01 00:00:001215
20142015-01-01 00:00:0023142
20142014-09-01 00:00:001210
20142014-07-07 00:00:0023144

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.

0 Replies