topic Re: Substitute a simple if statement with a variable not working in App Development

Substitute a simple if statement with a variable not working

Applicable88 — Fri, 03 Jul 2020 06:04:14 GMT

Re: Substitute a simple if statement with a variable not working

lironbaram — Fri, 03 Jul 2020 08:59:08 GMT

you forgot to explain what is not working

Re: Substitute a simple if statement with a variable not working

Applicable88 — Fri, 03 Jul 2020 09:29:46 GMT

Oh... @lironbaram ,

apparently the Forum had the maintenance session while I posted. Thank you for telling me.

I have following question:

As you know you can also change the title of a straight table with a variable and a switch button dynamically like this:

if(vTest='0', 'Zero','One') That works perfectly , no problem at all.

I now have a straight table with serialnumbers , status and a date :

=if(vTest='0',count({$<Status2={'K'}>}Serialnumbers),count({$<Status2={'V'}>}Serialnumbers)) The table said its invalid. Why its not going to work? Its basically only saying if variable='0' than do this count otherwise the other count.

And I want to add that I need this as a dimension not measure, so that I can also use it as a bar-chart dimension later on.

If I'm using the functions separetely without variable it also works perfectly : count({$<Status2={'K'}>}Serialnumbers) or when using this count({$<Status2={'V'}>}Serialnumbers)

Re: Substitute a simple if statement with a variable not working

brunobertels — Fri, 03 Jul 2020 09:30:13 GMT

you need to run your variable to make your if statement works so the mesure should be

=if($(vTest)='0',count({$<Status2={'K'}>}Serialnumbers),count({$<Status2={'V'}>}Serialnumbers))

Re: Substitute a simple if statement with a variable not working

Applicable88 — Fri, 03 Jul 2020 09:34:20 GMT

Hello @brunobertels ,

thx, but doesn't solve the problem. Seems to be another issue. The DSE makes no difference here.

Re: Substitute a simple if statement with a variable not working

brunobertels — Fri, 03 Jul 2020 11:16:42 GMT

I assume that you have declared your variable in the control variable panel :

have you test your mesure in a KPI , is the behaviour the same ?

Re: Substitute a simple if statement with a variable not working

lironbaram — Sun, 05 Jul 2020 14:24:50 GMT

if your variable is numeric this should work

=if($(vTest)=0,count({$<Status2={"K"}>}Serialnumbers),count({$<Status2={"V"}>}Serialnumbers))

Re: Substitute a simple if statement with a variable not working

NitinK7 — Sun, 05 Jul 2020 15:06:22 GMT

May your varible value is numeric 0 and check 0 as string . Plase write 0 instead of '0' in if condition.

Try like below

=if($(vTest)=0,count({$<Status2={"K"}>}Serialnumbers),count({$<Status2={"V"}>}Serialnumbers))

Re: Substitute a simple if statement with a variable not working

Applicable88 — Mon, 06 Jul 2020 07:58:13 GMT

Hello,

apparently its not a string or number problem.

I think its simply how this function displays the counts. Even the set expression already filter K or V. Really makes no sense to me.