topic Re: Variable definition in Expression in App Development

Variable definition in Expression

LukaIT — Thu, 31 Aug 2023 12:47:43 GMT

I have this simple Expression and my question is can I and how to make things simple?

Metroplex-1={'1'} needs to be changed to 2,3,4,5,6,7 in other expressions (I copy-paste it 6 times and then change '1' to '2' in the whole expression which is really painful and a waste of time.

Can I use Variable for [Metroplex-1] in Expression so that instead of changing 10 times I change Variable in Expression on one place and Expression is using it? or any other suggestions on how to make things a bit faster.

Thanks

My Expression:

(((Count({$<FleetBookAgreement={'Rental'},[Metroplex-1]={'1'}>}FleetBookAgreement)+
Count({$<FleetBookAgreement={'Booking'},resStatus_Name={'Active'},[Metroplex-1]={'1'}>}FleetBookAgreement))
-
Count({$<FleetBookAgreement={'Rental'},CountXto-={1},[Metroplex-1]={'1'}>}FleetBookAgreement))
-

((Count({$<FleetBookAgreement={'Rental'},res7day={'N'},[Metroplex-1]={'1'}>}FleetBookAgreement)+
Count({$<FleetBookAgreement={'Booking'},resStatus_Name={'Active'},res7day={'N'},[Metroplex-1]={'1'}>}FleetBookAgreement))
-
Count({$<FleetBookAgreement={'Rental'},CountXto-={1},res7day={'N'},[Metroplex-1]={'1'}>}FleetBookAgreement))

+
(Count({$<IgnoreOOS={'Y'},[Metroplex-1]={'1'}>}OOS)
-Count({$<IgnoreOOS={'Y'},res7day={'N'},[Metroplex-1]={'1'}>}OOS))
-Count({$<IgnoreOOS-={'Y'},res7day={'N'},OOSgroup={'Mirovanje'},[Metroplex-1]={'1'}>}OOS))

/
(
Count({$<TYPE={'FleetHistory'},PlanType-={'Defleeted'},Future={'N'},[Metroplex-1]={'1'}>}distinct XCarPlateno)+Sum({$<Future={'Y'},Xyear={$(vCurYear)},[Metroplex-1]={'1'}>}poKOM)+Count({$<Future={'Y'},[Metroplex-1]={'1'}>}distinct CarId)
+Count({$<Type={'OW'},Future={'Y'},[Metroplex-1]={'1'}>}OWplusId)
-
Count({$<Type={'OW'},Future={'Y'},[Metroplex-1]={'1'}>}OWminusId)

-Count({$<IgnoreOOS-={'Y'},Future={'Y'},OOSgroup={'Mirovanje'},[Metroplex-1]={'1'}>}OOS))

Re: Variable definition in Expression

marcus_sommer — Thu, 31 Aug 2023 13:01:28 GMT

It's not clear which number do you want to adjust - within the field or the field-value?

[Metroplex-1]={'1'}

Re: Variable definition in Expression

LukaIT — Tue, 31 Oct 2023 11:29:33 GMT

[Metroplex-1]={'1'}

[Metroplex-1]={'2'}...

Re: Variable definition in Expression

marcus_sommer — Wed, 01 Nov 2023 08:24:18 GMT

You may replace it with a variable which would change the call to:

[Metroplex-1]={$(myVar)}

An alternatively would be to use a field-selection for it. Most simple would be to provide the field [Metroplex-1] directly which would be the most natural way - the user just selects what's interesting. But you may also provide a not related field per island-table and then the call may look like:

[Metroplex-1] = p(MySelectionField)

Re: Variable definition in Expression

LukaIT — Thu, 09 Nov 2023 12:50:00 GMT

Hi Marcus,

could I define myVar in Expression?

This is KPI and it has around 30 expressions in each group.
Each group has its own Metroplex 1,2,3,4... so instead of changing each expression, the Metroplex number 10-20 times I would like to change 1 variable on the top of the expression, and with it I won't need to edit 500-600 variables 🙂

Hoping you understand me

The user is not selecting anything, if needed they use filters but this is a KPI that is divided into 11 metroplexes so you can see each of them without filtering

Thanks

Re: Variable definition in Expression

marcus_sommer — Thu, 09 Nov 2023 13:17:57 GMT

You may use parametrized variables, like:

myVar:
sum({< $1 = {$2}>} $3)

and calling them like:

$(myVar(Field1, ValueXYZ, Field2))

which could reduce the number of needed variables quite significantly.

But you will further need to adjust this variable-expression by each call. You are just minimizing the lengths of the expression which has benefits (easier to maintain) as well as disadvantages (loosing overview).

More simple and more performant would be to use table-charts instead of KPI objects. It won't provide this amount of layout-capabilities but is also able to display the essential information.