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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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