topic Re: Getfield selections in QlikView

Getfield selections

ipauldur — Thu, 23 Jun 2011 06:55:32 GMT

Hi,

I need to get the selected values on field.

I know that, we can use "Gtefieldselections(Fieldname)" function. But if we do search on the field(or list box) ans selecting the values, then the fuction returning only the searching value. For example, ABC is a field name. If we are searching the value "*rcs*" on "ABC" field, then the "Getfieldselections" fuction only displaying the value *rcs*. But i want to display the full name like "Rcs Retail".

Any other suggestions will be appreciated.

Thanks,

Durai.

Re: Getfield selections

kaushiknsolanki — Thu, 23 Jun 2011 07:21:12 GMT

Hi,

I have tried to do this with macro.

Have a look at the example.

Regards,

Kaushik Solanki

Re: Getfield selections

ipauldur — Thu, 23 Jun 2011 07:49:45 GMT

Hi Kaushik,

Thank you so much. Its working fine.

I am just curious, can we include some other text in the same text box?.

For example, when we show the values on text box, need to include reporting period also.

Eg: "Reporting for Jan 2011 (Build,implementation)" .This "Jan 2011" is one of the variable for dynamic changes.

Is it possible on the same text box?

once again thanks for your answere.

Regards,

Durai.

Re: Getfield selections

kaushiknsolanki — Thu, 23 Jun 2011 07:56:25 GMT

Hi,

From where do you get this Reporting for Jan 2011.

Meaning Jan 2011 coming from variable/Field.

Regards,

Kaushik Solanki

Re: Getfield selections

ipauldur — Thu, 23 Jun 2011 08:35:18 GMT

Hi Kaushik,

Thank you so much. Its working fine.

I am just curious, can we include some other text in the same text box?.

For example, when we show the values on text box, need to include reporting period also.

Eg: "Reporting for Jan 2011 (Build,implementation)" .This "Jan 2011" is one of the variable for dynamic changes.

Is it possible on the same text box?

once again thanks for your answere.

Regards,

Durai.

Re: Getfield selections

ipauldur — Thu, 23 Jun 2011 08:37:57 GMT

Hi,

That is coming from the variable.Basically the user will give period in input box as "YYYYMM" format.

Thanks,

Durai.

Re: Getfield selections

ipauldur — Thu, 23 Jun 2011 08:38:55 GMT

Hi,

That is coming from the variable.Basically the user will give period in input box as "YYYYMM" format.

Thanks,

Durai.

Re: Getfield selections

kaushiknsolanki — Thu, 23 Jun 2011 09:09:55 GMT

Hi,

Checkout this.

Regards,

Kaushik Solanki

Re: Getfield selections

ipauldur — Thu, 23 Jun 2011 09:32:13 GMT

Hi Kaushik,

Thank you very much..Its meeting my expectation.

Thanks,

Durai.