topic Re: multiple field values with special characters in QlikView

multiple field values with special characters

ssriramin19 — Tue, 12 Sep 2017 08:23:21 GMT

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

Re: multiple field values with special characters

Anil_Babu_Samineni — Tue, 12 Sep 2017 08:26:07 GMT

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

];

Re: multiple field values with special characters

its_anandrjs — Tue, 12 Sep 2017 08:28:14 GMT

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

Re: multiple field values with special characters

ssriramin19 — Tue, 12 Sep 2017 08:33:17 GMT

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

Re: multiple field values with special characters

ssriramin19 — Tue, 12 Sep 2017 08:34:28 GMT

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

Re: multiple field values with special characters

PrashantSangle — Tue, 12 Sep 2017 08:36:49 GMT

Write on open trigger from sheet property.

Select in field> enter field Name

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

Regards

Re: multiple field values with special characters

its_anandrjs — Tue, 12 Sep 2017 08:41:51 GMT

Then go for the field event triggers.

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

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.

Re: multiple field values with special characters

ssriramin19 — Tue, 12 Sep 2017 08:43:26 GMT

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

Re: multiple field values with special characters

Anil_Babu_Samineni — Tue, 12 Sep 2017 08:49:07 GMT

Are you need this as Static / Dynamic ??

Re: multiple field values with special characters

ssriramin19 — Tue, 12 Sep 2017 08:51:52 GMT

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

Re: multiple field values with special characters

its_anandrjs — Tue, 12 Sep 2017 08:56:12 GMT

Suppose if you introduce this FieldFlag in your data model fir the field product_name and your product_name field has many values on that field but you need to select only this five values then you can use this Flag_Field for selections.

Re: multiple field values with special characters

ssriramin19 — Tue, 12 Sep 2017 09:02:10 GMT

Do I need to select the field flag to 1 ? Do I need to manually select the field flag and select it to 1?

Can you clarify on that

Re: multiple field values with special characters

ssriramin19 — Tue, 12 Sep 2017 09:39:58 GMT

can you please clarify on this

Re: multiple field values with special characters

effinty2112 — Tue, 12 Sep 2017 09:52:04 GMT

Maybe:

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

good luck

Andrew