topic Re: Set analysis with formula and condition in App Development

Set analysis with formula and condition

Fitus9092 — Tue, 07 Nov 2023 07:06:00 GMT

Hello i'm trying to use this formula in set analysis but it not work.

Count( {< esclusione = {'0'} , esclusione2 = {'1'}, Diff ={"=<90"}>} progressivoSDO_IMA_STEMI_PTCA)

Diff is a variable system with this formula :

num#(interval((dataInterventoPrincipale&' '&oraInterventoPrincipale - [dataora triage]),'mm'))

I tried this second formula in set analysis but doesen't work
Count( {< esclusione = {'0'} , esclusione2 = {'1'}, {="num#(interval((dataInterventoPrincipale&' '&oraInterventoPrincipale - [dataora triage]),'mm'))"} = {"<=90"} >} progressivoSDO_IMA_STEMI_PTCA).

Thanks

Re: Set analysis with formula and condition

Vegar — Tue, 07 Nov 2023 07:37:29 GMT

Set modifier should be defined for fields will not work on expressions. I usually think of the modifiers as invisible selections made to the datamodel before calculating the expression.

Are you able to pre generate the num as a field in the script?

num#(interval((dataInterventoPrincipale&' '&oraInterventoPrincipale - [dataora triage]),'mm')) as [Diff]

If you are then the set can look like this in your application.

Count( {< esclusione = {'0'} , esclusione2 = {'1'}, Diff ={"=<90"}>} progressivoSDO_IMA_STEMI_PTCA)

Re: Set analysis with formula and condition

Fitus9092 — Tue, 07 Nov 2023 07:41:36 GMT

It works, many thanks!

Re: Set analysis with formula and condition

Vegar — Tue, 07 Nov 2023 07:44:18 GMT

Glad to help. Thank you for the fast feedback.