topic Re: Select In Feild in QlikView

Select In Feild

maahivee — Thu, 30 Apr 2015 19:21:04 GMT

Hello Guys,

I have a situation where if anything selected from the location code should automatically be selected in Warehouse code

the data in both the fields is same and coming from two different tables but i renamed it different because i dont want any circular loops.

but in the front end i wrote a trigger which "=if(GetSelectedCount([Warehouse Code])>0,'('&Concat(Distinct [Warehouse Code],'|')&')')"

for the location code. please help its urgent!!!!

Re: Select In Feild

sunny_talwar — Thu, 30 Apr 2015 19:44:04 GMT

I am sorry, but I am not sure hat is your question? Is the trigger not working or are you asking if it will create a loop if the two fields are named the same?

Re: Select In Feild

maahivee — Thu, 30 Apr 2015 19:45:35 GMT

I am afraid that it will create a loop if i rename one of those columns and just wrote a trigger for that feild and its not working.

Re: Select In Feild

maxgro — Thu, 30 Apr 2015 19:45:49 GMT

=if(GetSelectedCount([Warehouse Code])>0

,'("' & concat(DISTINCT [Warehouse Code], '"|"') & '")'

,''

)

Re: Select In Feild

maahivee — Thu, 30 Apr 2015 19:54:40 GMT

Hi Massimo,

I tried using this expression and its working in my case.

And if i implement it and try to make a selection it is not working and if i clear everything it is still being showed in the selection box. please help.

Also i wrote this trigger under select in field and field name is location code and expression is the one you said.

Thank you

Re: Select In Feild

sunny_talwar — Thu, 30 Apr 2015 19:55:43 GMT

So you are copying over the selection made in location code to Warehouse Code right?

You will need to put a select in field trigger on the field Location code and field name you will be triggering to will be Warehouse Code and your expression will be:

=If(GetSelectedCount([Location Code]) > 0, '(' & Concat(DISTINCT [Location Code], '|') & ')' )

HTH

Best,

Sunny

Re: Select In Feild

maahivee — Thu, 30 Apr 2015 20:00:40 GMT

Thank you so much sunny, this is really helpful

Re: Select In Feild

maxgro — Thu, 30 Apr 2015 20:07:13 GMT

maybe because I wrote warehouse code instead of location code