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 problem

Hello everybody,

I have a TOP/FLOP in my application. No problem for my TOP but my FLOP don't work.

TOP FLOP.bmp

Here my expression :

  =sum({$<SINI_CLO_BDG={">0"}>} SINI_CLO_BDG)
/
sum({$<FAMILLE_TACHES={"Sinistre BDG"},TEMPS_DUREE= {">0"}>}TEMPS_DUREE)

Nota : When I isolate the two expressions, the first part works, not the second part.

Is anyone have an idea ?

Emmanuelle

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

No evident errors,

I should use ' instead of "

sum({$<FAMILLE_TACHES={'Sinistre BDG'},TEMPS_DUREE= {'>0'}>}TEMPS_DUREE)


but I don't think this is the problem.


Try to split to better analyze:


sum(TEMPS_DUREE) Works?

sum({$<FAMILLE_TACHES={'Sinistre BDG'}>}TEMPS_DUREE) Works?

sum({$<TEMPS_DUREE= {'>0'}>}TEMPS_DUREE) Works?


Let me know


MK_QSL
MVP
MVP

If possible, load your sample data files