topic Re: Select In Field in QlikView

Select In Field

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm Trying to use Select In Field action -

i have 4 different fields with the value "1"

and variable vMonth (input field - 6,12,18..) .

what I'm trying to do with the action is :

Field:

if(vMonth=6, Field1,

if(vMonth=12, Field2 and so on))

Search String:

but its not working..

Re: Select In Field

Anonymous — Sun, 09 Apr 2017 07:29:58 GMT

Can you share a sample??

Re: Select In Field

Anonymous — Sun, 09 Apr 2017 07:37:34 GMT

Sorry, i cant share a sample ..

but i will try to explain it :

i have 4 fields which represents flags for every customer.

in the UI , if the user select 6 in the vMonth variable so the action will work on filed 1

and if the user selects 12 in the vMonth variable so the action will work on filed 2 and so..

work means - search the value 1 and select the relevant customers .

Re: Select In Field

Anonymous — Sun, 09 Apr 2017 07:47:38 GMT

How about creating 4 select in field actions?? each one like field 1, Search String:if(vMonth=6, 1)

Re: Select In Field

Anonymous — Sun, 09 Apr 2017 07:50:38 GMT

yes , definitely an option , but i thought there is another way like the one i wrote about.

Re: Select In Field

Anonymous — Sun, 09 Apr 2017 07:57:16 GMT

Am not sure if that can be done. Let's see if some expert helps us.

Re: Select In Field

vinieme12 — Sun, 09 Apr 2017 09:17:52 GMT

Create a variable for the field as below

vfield =

if(vMonth=6, 'Field1',

if(vMonth=12, 'Field2' and so on))

And use the variable for field name

$(vfield)

Re: Select In Field

Anonymous — Sun, 09 Apr 2017 09:44:06 GMT

Hi,

thanks for your reply.

but it didn't work..any other idea?

Re: Select In Field

sunny_talwar — Sun, 09 Apr 2017 13:32:28 GMT

May be like attached?

Re: Select In Field

Anonymous — Sun, 09 Apr 2017 13:38:41 GMT

Thanks Sunny!

Good enough for me

but how did you do it?

Re: Select In Field

sunny_talwar — Sun, 09 Apr 2017 13:48:12 GMT

I added 4 select in field triggers instead of 1.

Field

Field1

Search String

If(vMonth = 6, 1)

Field

Field2

Search String

If(vMonth = 12, 1)

Field

Field3

Search String

If(vMonth = 18, 1)

Field

Field4

Search String

If(vMonth = 24, 1)

Re: Select In Field

Anonymous — Sun, 09 Apr 2017 13:52:02 GMT

well i cannot see the triggers 😕

where did you add them?

Re: Select In Field

Anonymous — Sun, 09 Apr 2017 13:52:34 GMT

In the Document properties- Triggers- Variables

Re: Select In Field

sunny_talwar — Sun, 09 Apr 2017 13:54:45 GMT

Yup... as Shiva pointed out... it is in Document Properties... I have used the trigger for vMonth... So based on the value (6, 12, 18, 24) entered, one of the fields will select 1