multiple field values with special characters

[ssriramin19]

Hello All,

There is a field (product_name) with the values ((FP@HUBMCDC,FP@MCDC,FP@PS&MCDC,FPIRP@MCDC,FP@XD&MCDC)

My requirement is that on open the above field values has to be chosen

With the special character appearing in the field values the default values are not being chosen on opening the report.

Can anyone please let me know how to approach the above issue.

Thanks

Sriram

[Anil_Babu_Samineni]

What is the output you need from given data?

Load * Inline [

product_name

FP@HUBMCDC

FP@MCDC

FP@PS&MCDC

FPIRP@MCDC

FP@XD&MCDC

];

[its_anandrjs]

Explain more on this it seems you need to select only rows where you have "@" symbol.

[ssriramin19]

its not the @ symbol I need to show as the default selection but the five values the business users are requested the values should be chosen when the report is open

[ssriramin19]

I can't able to do inline load for this five field values alone , This field has more than hundred values and I need to show only the five values for the field when the report is being opened

Kindly suggest some option

[PrashantSangle]

Write on open trigger from sheet property.

Select in field> enter field Name

value > 'value1 | value2 | value3 | value4 | value 5'

Regards

[its_anandrjs]

Then go for the field event triggers.

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Document_Properties_Triggers.htm

Or

In the load script make changes this way

Load

*,

If( Match( product_name, 'FP@HUBMCDC','FP@MCDC','FP@PS&MCDC','FPIRP@MCDC','FP@XD&MCDC'),1,0) as FieldFlag

From Source;

And after this on the Field Event Triggers use this field FieldFlag = 1 if you select this field value 1 all data related to this get selected.

[ssriramin19]

I tried to give it like this

(FP@HUBMCDC|FP@MCDC|FP@PS&MCDC|FPIRP@MCDC|FP@XD&MCDC)

But the values FP@PS&MCDC and FP@XD&MCDC are not being selected .

Can any one please suggest what needs to be done

[Anil_Babu_Samineni]

Are you need this as Static / Dynamic ??

[ssriramin19]

Can you please elaborate on the above method,I am not clear on the method

Also I intend not to select any field values ( in this case field flag ) So in the above method only if the field flag is chosen to be 1 the five values for the field product_name would be chosen. Can you please explain on this