Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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