Inline With If Statement

[pgalvezt]

Hello,

In my dashboard I have a Multibox from this table:

Div:

LOAD * INLINE [

    Symb,Div

    $, 1

    M$, 1000

    MM$, 1000000

];

And I Have Another Field from another table (Field A)

So I don´t know if its posible but What I want is:

IF(Field A = 'Click On that Field',

LOAD * INLINE [

    Symb,Div

    $, 1

];

,

LOAD * INLINE [

    Symb,Div

    $, 1

    M$, 1000

    MM$, 1000000

];

The Idea its block the value M$ and MM$ when user select 'Click On that Field',

Thanks!

[pgalvezt]

I prepared a test QV for better comprenhession,

Thanks!

[vishsaggi]

Sorry could not check this yesterday, will look into this today.

[pgalvezt]

Ok. No Problem, I hope you could help me with this.

Thanks!

[vishsaggi]

Ok so what was the issue? You have two list boxes which are Always one Selected value checked. That is the reason you cannot select the values in your Simbilio field. So what exactly you are expecting here?

[pgalvezt]

I expect this:

you mean when you click on UF your Multibox should show only 1 else show 1, 100, and 1000000?

What you mean by blocked?

I Need to block $ when user select UF...

Thanks!

[vishsaggi]

Thats what i said your selections in Simbolo field will not reflect any bcos you have always one selected values for your other list box. So when you click on UF is Simbolo not showing only $?

[pgalvezt]

So, from your perspective is this requirement impossible, or can there be an alternative attached?

Thanks!

[vishsaggi]

I totally did not understand what exactly your expected functionality you are looking for. With the file you sent, i can see there are two listboxes which has always one selected value checked. So based on that your Simbolo field is used. So when you select the value in Simbolo it will not change coz the for that selected value you can see all values displayed based on field selection. However, when you select Value UF then the simbolo field changes to $. So, correct me here, when you select apart from value UF you can see all 3 values in your simbolo, so you want to select any of those 3 values the data should change?

[vishsaggi]

Try this?

= Aggr(Only(IF(GetFieldSelections(VisualizarNumero) = 'Ver en UF', '$', Simbolo)), Simbolo)

you might have to create a field event trigger as well. For this. But try above and let me know.

[pgalvezt · Accepted solution]

I did it with your help !!!... I came up with the following: I took a picture of the weight symbol. I associated that photo with a text object that will appear conditionally when the following happens: = GetFieldSelections (VisualizeNumber) = 'View in UF' and GetFieldSelections (Symbol) = 'M $' Or GetFieldSelections (Symbol) = 'MM $' .. After this I changed the formula to the general table for this: = If (Display Number = 'View in UF' and Symbol = 'M $' or Symbol = 'MM $',

Sum (Balance),

Sum (Balance / Divisor) * sum ({<Month = {$ (xMesMax)}, Year = {$ (xYearMax)}>} Total Distinct ValueUF))..

So when the user always clicks on UF M $ and MM $ the sign $ will appear and the calculation will always be in $. It is as if it is blocked.