Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax issue, again, sorry


These works:

Sum({$<Labor={'Y'},Entitlement_LaborRate={">0"}>} Hours)  = Entitlement hours

Sum({$<Labor={'Y'}>} Hours) = Total Hours

Sum({$<Labor={'Y'}>} Hours) - Sum({$<Labor={'Y'},Entitlement_LaborRate={">0"}>} Hours)  = Standard hours

I want the total hours less the entitlement rate hours. . .  Basic math works,

set analysis, i can't figure out properly

However, the third statement should be able to be written like

Sum({$<Labor={'Y'}>,<Entitlement_LaborRate-={">0"}>} Hours)

or

Sum({$<Labor={'Y'},Entitlement_LaborRate-={">0"}>} Hours)

or so one would think . . .

neither of them work correctly

2 Replies
Carlos_Reyes
Partner - Specialist
Partner - Specialist

Maybe this:

Sum({$<Labor={'Y'},Entitlement_LaborRate={"<=0"}>} Hours)

Anonymous
Not applicable
Author

carlos.reyes.qv is right.

carlos.reyes.qv está en  lo correcto.

Regards.