Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i am trying to filter a field through set analysis with a set of values less than a number but i cannot make it work. My syntax is:
count({$<[Délai statut 6 - Statut 3]={"<5"},[Délai statut 6 - Statut 3]-={"999999"},[Sélection KPI]={"1"},[Regroupement]={"PRO","FIL"}>}[Commande client])
WHat is not working is the [Délai statut 6 - Statut 3]={"<5"}. If i put or notit gives the same result.
Thank you,
Lawrence
Hi
Please use the below expression:
count({$<[Délai statut 6 - Statut 3]={"<5"},[Sélection KPI]={"1"},[Regroupement]={"PRO","FIL"}>}if([Délai statut 6 - Statut 3]<>999999,[Commande client]))
Regards
Pratyush
Hi
Please use the below expression:
count({$<[Délai statut 6 - Statut 3]={"<5"},[Sélection KPI]={"1"},[Regroupement]={"PRO","FIL"}>}if([Délai statut 6 - Statut 3]<>999999,[Commande client]))
Regards
Pratyush
Hi, my problem is with the [Délai statut 6 - Statut 3]={"<5"} as mentioned above.
Thanks,
Lawrence
Hi Lawrence
That's not a problem, since you're providing two conditions for the same field, it is getting confused and is using the second condition. I understand what you're trying to achieve but it is not possible that way.
Regards
Pratyush
Hi all,
In the Set Analysis can be used multiple conditions for a single field. If the logical intersection (And), the set expression to be written approximately as follows (in each condition curly braces)
{<...{Condition1}*{Condition2}...>}
If the logical addition (Or), the set expression to be written approximately as follows
{<... {Condition1} + {Condition2} ...>}
Conditions themselves inside the curly brackets should also be presented by the expression Set Analisys.
Regards,
Andrey
Thank you for such a clear explanation.
Regards
Pratyush
Hi Andrey,
could you pleasegive the exact syntax for my case?
Thank you,
Lawrence
Hi Lawrence,
It should be like this, if I understand correctly, what is required in the selection
count({$<[Délai statut 6 - Statut 3]-={"999999"}>*<[Délai statut 6 - Statut 3]={"<5"},[Sélection KPI]={"1"},[Regroupement]={"PRO","FIL"}>}[Commande client])
Regards,
Andrey
I tried to simulate your expression, as I understand it. An example of the attached file.
The application loaded the numbers 1 to 10 in the field ID. Then indicators are created with Set Analisys. Play selections, please, in the ID field.
Regards,
Andrey