topic Re: To create a button object in the sheet. in QlikView

To create a button object in the sheet.

Fri, 17 May 2013 05:42:38 GMT

Hello Everybody,

I'm working on button sheet object. Need some help how to write expression to link with the selected data in a table.

For example : I've a field name called 'SubjectCode'. Many codes are given in the field. A1,A2,A3,A4,A5,B1,B2,B3,B4,B4,B5

I need to create a button object to display only'A1,A2,A3,B1,B2' from Subjest Code.

My analysis :

I've created a button name 'Code' -> Properties-> Bookmark-> Apply bookmark (Given the 'Subject Code' label name)

Then Selections-> Select in Field-> Feild name (Subject Code) & Search String-> if (Match([Subject Code],'A1',A2','A3','B1','B2'),' ')

But it seems to be not working.

Can anyone help me how to do this will be very helpful.

Regards,

Archana.

Miguel_Angel_Baeyens — Fri, 17 May 2013 05:54:24 GMT

Hi Archana,

In the actions expressions, the way to select multiple values is this, manually adding all the values you want to select:

(A1|A2|A3)

So one way to get this done in the search string would be

='(' & Concat(Distinct Field, '|') & ')'

Hope that helps

Fri, 17 May 2013 06:46:51 GMT

I've attached the sample .qvw here.

Please help me out of this issue.

kumarnatarajan — Fri, 17 May 2013 06:55:11 GMT

Hi,

fiend the attached file. you must give currect field name in select in field

Fri, 17 May 2013 06:55:47 GMT

PFA document

Regards,

Amay

Fri, 17 May 2013 07:49:00 GMT

Hi,

Thanks for your help.

But i do need only particular values in the feild. I tired giving

='('& concat(distinct [size code], 'A1|A2|A3|B1|B2')& ')'

But i get the values A2,A3,B1. The first and last values are not selected when i click to the button.