topic If and else condition Not working without the filter. in App Development

If and else condition Not working without the filter.

deepanshuSh — Sat, 17 Dec 2022 12:45:18 GMT

So to put it in a simple way, there is an if and else condition that is based on 3 fields and three tags associated to it. The app and logic was working before, the code is shown as below.

The logic works fine when you have selected the filter (i.e Registration Number =0), otherwise it shows 0 value. I am not able to understand why its not working anymore and how to resolve it.

Num((Count((If(MY_AUDI_Vehicle_VIN=VIN,
(if(registrationNumber_tag=0,registrationNumber,
if([Reg. No._tag]=0, [Reg. No.]))),
If(DMS_VIN=VIN,(if(registrationNumber_tag=0,registrationNumber,
if([Reg. No._tag]=0, [Reg. No.]))))
))
))

Re: If and else condition Not working without the filter.

rubenmarin — Sun, 18 Dec 2022 11:20:38 GMT

Hi, if an expression (or field) has more than one possible value it returns null, so maybe registrationNumber_tag=0 or [Reg. No._tag]=0 can only be evaluated when there is a selection that reduces the multiple values of those fields to a single value that can be evaluated.

You can check this adding a text box for each field with the expression =registrationNumber_tag or =[Reg. No._tag] and check how it changes with selections.

Without knowing the intention of your expression or the model behind I think the option here is to enclose in an aggr that evaluates the different combinations of values, like:

Num(Sum(Aggr((Count((If(MY_AUDI_Vehicle_VIN=VIN,
(if(registrationNumber_tag=0,registrationNumber,
if([Reg. No._tag]=0, [Reg. No.]))),
If(DMS_VIN=VIN,(if(registrationNumber_tag=0,registrationNumber,
if([Reg. No._tag]=0, [Reg. No.]))))
))
),MY_AUDI_Vehicle_VIN,registrationNumber_tag,[Reg. No._tag])))

Re: If and else condition Not working without the filter.

deepanshuSh — Mon, 19 Dec 2022 04:40:16 GMT

Thanku Ruben, I got the issue, it was from the data's end and I tried it using the aggr function it kind of worked but made the dashboard heavier, I resolved it from the backend only. To reduce the data load.