Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analylis "Sum"

Hello, I have the following diagram:

Set Analysis.png

And I have this expressions in a scatterplot:

Label: Tiempo,             Expression: Sum([Tiempo ocupación])

Label: Facturación,      Expression: Sum({$<[Historia ocupación] = [Historia factura], [Ingreso ocupación] = [Ingreso factura]>} [Total cargo])

and the dimension is _PK_Ocupacion.

I don't know why the Sum is not working and neither the scatterplot .

How can I solve that?

Thabk youv ery much.

4 Replies
Anonymous
Not applicable
Author

Juan,

Try this in the 2nd expression:

Sum({$<[Historia ocupación] = P([Historia factura]), [Ingreso ocupación] = P([Ingreso factura]P>} [Total cargo])

Anonymous
Not applicable
Author

Can you check the syntax please. It says that there is an error in set modifier element function.

Thanks!

Anonymous
Not applicable
Author

Sorry it was a missing )...

Great!

Anonymous
Not applicable
Author

Sadly... it didn't worked... all the values in the scatterplot are still 0.

Any other idea?