topic Re: Inline With If Statement in QlikView

Inline With If Statement

pgalvezt — Thu, 31 May 2018 21:41:38 GMT

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!

Re: Inline With If Statement

vishsaggi — Fri, 01 Jun 2018 00:22:09 GMT

Not completely clear, can you tell us what your FieldA values are? And what should be your expected output when you select any value in your FieldA. We can try using Mapping Load to map with your FieldA values. Cannot suggest until further information.

Re: Inline With If Statement

pgalvezt — Fri, 01 Jun 2018 14:43:31 GMT

Hello vishsaggi

Field A contains 2 options: 'Real' and 'UF'... So when UF is clicked the divisor number must be blocked.

UF Clicked:

LOAD * INLINE [

Symb,Div

$, 1

];

Any option is clicked except UF.

LOAD * INLINE [

Symb,Div

$, 1

M$, 1000

MM$, 1000000

];

Re: Inline With If Statement

vishsaggi — Fri, 01 Jun 2018 15:12:57 GMT

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

What you mean by blocked?

Re: Inline With If Statement

pgalvezt — Fri, 01 Jun 2018 20:13:13 GMT

Thats Right... Thats exactly what I want to achieve

Re: Inline With If Statement

vishsaggi — Fri, 01 Jun 2018 20:24:11 GMT

In your multibox for the field Div just write this expression like

= IF(GetFieldSelections(FieldA) = 'UF', 1, Div)

Re: Inline With If Statement

pgalvezt — Fri, 01 Jun 2018 21:42:13 GMT

Where must writte the expression inside the multibox... I didn't see expression on multibox.

Re: Inline With If Statement

vishsaggi — Fri, 01 Jun 2018 23:35:34 GMT

‌in the general tab of multibox properties window , in the middle you can see few buttons, the one before the edit buttons there is an expression button. There use this if condition changing the field names to your actualfieldname.

Re: Inline With If Statement

pgalvezt — Mon, 04 Jun 2018 17:20:46 GMT

vishsaggi

Found it! the problem is when I try to select any option $ $M $MM does not allow me to do it. I need the option "always a selected value". It seems that with the expression, the option disappears and shows me the 3 values. and as I mentioned you will not let me select 1 value.

Thanks!

Re: Inline With If Statement

vishsaggi — Mon, 04 Jun 2018 18:03:24 GMT

Can you share this qvw app where you implemented this if Condition?

Re: Inline With If Statement

pgalvezt — Mon, 04 Jun 2018 19:52:22 GMT

I prepared a test QV for better comprenhession,

Thanks!

Re: Inline With If Statement

vishsaggi — Tue, 05 Jun 2018 13:53:02 GMT

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

Re: Inline With If Statement

pgalvezt — Tue, 05 Jun 2018 14:33:49 GMT

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

Thanks!

Re: Inline With If Statement

vishsaggi — Tue, 05 Jun 2018 16:13:20 GMT

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?

Re: Inline With If Statement

pgalvezt — Tue, 05 Jun 2018 16:23:49 GMT

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!

Re: Inline With If Statement

vishsaggi — Tue, 05 Jun 2018 18:33:46 GMT

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 $?

Re: Inline With If Statement

pgalvezt — Tue, 05 Jun 2018 19:54:38 GMT

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

Thanks!

Re: Inline With If Statement

vishsaggi — Tue, 05 Jun 2018 20:51:44 GMT

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?

Re: Inline With If Statement

vishsaggi — Tue, 05 Jun 2018 21:19:43 GMT

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.

Re: Inline With If Statement

pgalvezt — Tue, 05 Jun 2018 21:29:13 GMT

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.