topic SelectField with different data in actions in QlikView

SelectField with different data in actions

jagannalla — Mon, 25 Jul 2011 05:21:20 GMT

Hi,

- If one of the field of qvd file contains like :

- We can write in button action for field like this if varibale contains the data (vA=10).

SeletedField(A) & value=$(vA)

- But if variable contains data like this vA=10,20,30. How can we implement of SelectedField with this data.

Re: SelectField with different data in actions

Mon, 25 Jul 2011 07:21:56 GMT

Hi,

You may like to use the subfield() function, or, use exists() function alongwith fieldvalue() function to retrieve the value. Depends on what selections you make and what your expected output should be.

Thanks.

SelectField with different data in actions

jagannalla — Mon, 25 Jul 2011 07:39:00 GMT

Hi,

The think is i've a table box with fields A,B,C and for field A i've data as i said before.

For Eg:

A with data(10,20,30,40.......)

- I'm storing the value 30 in vA variable.

- Now i wriiten in button action with SelectionField and with value for the field.

For Eg:

- And when i click the button i can see in the table with data of 30 in the column A.

- Now i will store in the variable vA with data (10,40).

- When i click the button i should see in the table box with 10,40 in the column A along with other fields of table box.

SelectField with different data in actions

kaushiknsolanki — Mon, 25 Jul 2011 07:52:20 GMT

Hi,

Try this expression in your search string.

=Replace('('&Variable2&')',',','|')

The reason is when you want to search more than one value you should include those value in this form (10|40)

and the above expression will give you the string in this format.

Regards,

Kaushik Solanki

SelectField with different data in actions

jagannalla — Mon, 25 Jul 2011 09:02:34 GMT

Thanks a lot kaushik..It's working

SelectField with different data in actions

jagannalla — Wed, 27 Jul 2011 07:01:29 GMT

- I've small doubt. I've a field A with data 10,20,30.

- When i written in button action with selectedfield and value as 20|30 why it is not working..

SelectField with different data in actions

kaushiknsolanki — Wed, 27 Jul 2011 08:43:15 GMT

Hi,

It should be in brackets. i.e (20|30)

Regards,

Kaushik Solanki

SelectField with different data in actions

jagannalla — Wed, 27 Jul 2011 08:47:49 GMT

Ok Thanks a lot..

Re: SelectField with different data in actions

jagannalla — Thu, 12 Jul 2012 10:43:17 GMT

Hi,

I need a help from you once again. When we have string or string with space in the column the above code is not working. Let me know what can i do.

Eg of my data is

Column1

B 1

C 2

C (cs1)

If i apply selectioninfield for column1 iwth code (A|B 1||C (cs1)) it is not working.