topic Re: Set analysis - constant values regardless of the filters in App Development

Set analysis - constant values regardless of the filters

Anonymous — Mon, 30 Oct 2017 10:48:16 GMT

Good Morning,

I am trying to create a KPI that shows the number of orders in arrears, according to the intervals that I defined:

1 day late

2 to 3 days late

4 to 6 days late

7 to 15 days late

+16 days late

In addition to the number of days in arrears, I need to consider two other constraints: vMissingUnit <0 and OrdStatus = confirm.

I want to show the number of overdue orders for each of the ranges in different views and so I need to write 5 expressions.

I started with some like this but it is not working:

1 day late -

Count({1<vNoDaysLate={"1"}, vNoMissingUnits={"<=1"}, OrdStat={"CONFIRM"}>}ItemOrd)

2 to 3 days late -

Count({1<vNoDaysLate={"2,3"}, vNoMissingUnits={"<=1"}, OrdStat={"CONFIRM"}>}ItemOrd)

I want these values to be constant regardless of the filters in use in my app.

Can someone help me, please? Thank you!

Re: Set analysis - constant values regardless of the filters

sunny_talwar — Mon, 30 Oct 2017 12:23:05 GMT

What is vNoMissingUnits? Is this a field or variable?

Re: Set analysis - constant values regardless of the filters

Anonymous — Mon, 30 Oct 2017 12:48:38 GMT

It's a variable!

Re: Set analysis - constant values regardless of the filters

sunny_talwar — Mon, 30 Oct 2017 12:50:00 GMT

What is the expression or field behind it? If it is a field... then it might still work... but you cannot have function on the left hand side of a set modifier

Re: Set analysis - constant values regardless of the filters

Anonymous — Mon, 30 Oct 2017 14:24:30 GMT

Its a function... vNoMissingUnit = FinUnits - OrdUnits, where FinUnits and OrdUnits are fields... vNoDaysLate is also a function. Can't I have variables like this two on the left side of a set modifier? Thank You!

Re: Set analysis - constant values regardless of the filters

sunny_talwar — Mon, 30 Oct 2017 14:29:09 GMT

Nope, this is not allowed... what are you trying to do? May be there is an alternative?

Re: Set analysis - constant values regardless of the filters

sunny_talwar — Mon, 30 Oct 2017 14:30:17 GMT

May be this

Count({1<ItemOrd = {"=Match(vNoDaysLate, 2, 3) and vNoMissingUnits <= 1 and OrdStat = 'CONFIRM' "}>}ItemOrd)

Re: Set analysis - constant values regardless of the filters

Anonymous — Mon, 30 Oct 2017 15:22:31 GMT

Thank you!

This expression doesn't work because it doesn't recognize vNoDaysLate and vNoMissingUnits as variables.

I am trying to create a KPI that shows the number of orders in arrears, according to the intervals that I defined:

1 day late

2 to 3 days late

4 to 6 days late

7 to 15 days late

+16 days late

The problem is that us intervals aren't a field so I don't know how to do it

Re: Set analysis - constant values regardless of the filters

sunny_talwar — Mon, 30 Oct 2017 15:24:00 GMT

Would you be able to share a sample?