topic Multiple table selections Conditional in QlikView

Multiple table selections Conditional

Sun, 26 Jul 2015 00:09:10 GMT

Hi everybody,

I have two multiple selection TIPO and UNIDAD

When you select a TIPO, there are only two or three UNIDADEs you can choose. It depends of the TIPO.

What I need is that if you select more than one TIPO you only can choose between PESOS and EUROS in the UNIDADES Multiple Selection. How in the namy of Messi and the Pope can I do this?

Thanks in advance!

Re: Multiple table selections Conditional

sunny_talwar — Sun, 26 Jul 2015 00:16:23 GMT

Not sure I understand, can you share a sample?

Re: Multiple table selections Conditional

Sun, 26 Jul 2015 00:58:51 GMT

Yes, look at the photos above I have pasted.

For example, if you choose PT in TIPO.. you only can choose beetwen EUROS, UOM, CAJAS and PESOS in UNIDAD.

If you select ME in TIPO.. you only can choose choose beetwen EUROS, UOM and PESOS in UNIDAD.

What I need is that if you select MORE than ONE diferents TIPOS (for example: MP and PT) the ony UNIDADES avalilables are PESOS and EUROS. No matters if you choose 2 or all the TIPOS if there are more than one, you only can choose from EUROS and PESOS.

Re: Multiple table selections Conditional

marcus_sommer — Sun, 26 Jul 2015 07:40:02 GMT

You could try to implement a relation between those fields in and-mode:

AND-Mode

AND and OR

or you need expression-filters for those multibox-fields. I'm not sure how these conditions look like and if simple expressions are enough or if you need advanced and/or nested expressions with an aggr, maybe something like this:

if(Count({< Unidad = p(Unidad)>} Tipo) > 0, Unidad)

- Marcus

Re: Multiple table selections Conditional

marcus_sommer — Sun, 26 Jul 2015 14:15:51 GMT

In addition here a (not) quite similar case but it might give some ideas: Re: Regarding Avg.

- Marcus

Re: Multiple table selections Conditional

Sun, 26 Jul 2015 14:16:41 GMT

Hi Marcus,

I understand the AND-OR Mode, but I think it is not enought.

The problem I have is that all of theses TIPOS have in comon this UNIDAD : PESOS, EUROS and UOM.
What I need is that when you select TWO TIPOS, the only UNIDAD posible be PESOS and EUROS but NOT UOM.

I have a very poor english, please, let me know If you could understand me.

Thanks a lot in advance!

Re: Multiple table selections Conditional

marcus_sommer — Sun, 26 Jul 2015 14:52:05 GMT

Here a small example of such a filter-expression.

- Marcus

Re: Multiple table selections Conditional

Sun, 26 Jul 2015 15:48:36 GMT

Marcus, Genius !!!

I use some of the data you gave me.

I was trying to solve this using a Multiple Selection Object. When I use the list box I can use expresion.
So I do this

=if(GetSelectedCount(Tipo)>1 ,if( todo=1,UM ), UM)

If the user select more than one TIPO, they only can see the UM where the field TODO is 1. I previusly create that field and insert a 1 in PESOS and EUROS and 0 to the others UM.

But If the user only select 1 TIPO he can select all the UM for these TIPO.

Thanks a lot!!

Re: Multiple table selections Conditional

Mon, 27 Jul 2015 14:37:22 GMT

Sorry Marcus,

But I realised my solution does not work at all.

When you select 2 or more TIPOs my filter shows whats it has to shows you (only PESOS and EUROS). But when select from my filter PESOS or EUROS automatically select ALL from TIPOS.

I do not understand what is happening here.

my filter is a List Table with this code.

=if($(vTiposCount) = 0, UM,

if($(vTiposCount) = Todo,UM))

I do not know how to add an example here.

Can yo give some help please ???

In my list

Re: Multiple table selections Conditional

marcus_sommer — Mon, 27 Jul 2015 15:15:49 GMT

If you clicked on answer you could change the editor-mode on the top-right from answer-window and there you will find on the bottom-right the possibility to attach a file.

- Marcus

Re: Multiple table selections Conditional

Tue, 28 Jul 2015 13:58:39 GMT

Here Marcus !

You will be able to undersand me now !!

Re: Multiple table selections Conditional

marcus_sommer — Wed, 29 Jul 2015 10:13:56 GMT

Your example is slightly different to mine and I'm not sure if it's covered your needs. I think you should extend your data and logics a little bit and makes some further attempts. I have added a few objects to see better what happens if anything will be select.

Sometimes you will get some handlings disadavantages with calculated listboxes and if you are not happy with them you need to think about other solutions. Maybe you could create such logic within the script or at least some parts from it, maybe something like this:

CurrencyMatch:

Load Tipo, autonumber(concat(UM, ' + ')) as [UM Total-ID] Resident xyz group by Tipo;

- Marcus

Re: Multiple table selections Conditional

Wed, 29 Jul 2015 18:34:49 GMT

I undestand what you said. But It still doensn't work for me.

I need that only PESOS and EUROS were abailable if user select more than one TIPO.

In this example, I do not know why, they can choose between Pesos and Uom. Totally stranger.

Even more, once you choce PESOS for example, the selection of the TIPOS is lost !!!!

I really need help with this!!!

Re: Multiple table selections Conditional

marcus_sommer — Thu, 30 Jul 2015 06:32:51 GMT

It could be very difficult to create such solution without disadvantages then you want not select over normal fields else calculated dimensions and this is in your case more a (usability) workaround. I'm not sure if such approach to simplify the user actions is always helpful - they could loose (very important) relations to the data they are looking on.

As an alternatively you could keep your native fields and provide the users those informations as help within the listbox, for example concat(distinct UM, ' + ') as additionally expression within the listbox for Tipo.

If I understand the relation from Tipo to UM right then is they fix and not depending from selections. Therefore you should consider solution (parts) within the script (at first the and-mode).

- Marcus