topic Parsing data in QlikView

Parsing data

Anonymous — Thu, 29 Jul 2010 22:16:32 GMT

I have list box values like pod1,pod2,\\pod1,\\pod2,pod3 and so on ,

i do not want \\ to be displayed , how do i remove them from the value and display the list box values just as pod1,pod2,pod3

Do i have to do this in the load script or in the list box properties?

Basically i want to treat \\pod1 = pod1.

Please Help....

Parsing data

Anonymous — Thu, 29 Jul 2010 22:38:24 GMT

Try using the Replace function in your script.

Parsing data

wizardo — Fri, 30 Jul 2010 07:59:45 GMT

put this in the listbox expression:

PurgeChar( field_with_pod_values , '\\' )

you should consider that selecting POD1 will select associated records both of "POD1" and of "\\POD1"

Mansyno

Parsing data

Anonymous — Mon, 02 Aug 2010 18:12:05 GMT

Thank you , and also i have some value like pod1 and POD1 how do i consider both as one,

is there a function which considers both lower case and upper case as single value ?

Parsing data

wizardo — Mon, 02 Aug 2010 21:01:57 GMT

hmm well

you can use the upper() and lower() functions to achieve that (look at the inside help)

but if you dont need to keep the original values you might want to consider moving the treatment of these values to the script and maybe you use a mapping table to force all values to be the same

Mansyno