topic Re: Data Clean Up in QlikView

Data Clean Up

Thu, 18 Dec 2014 22:13:34 GMT

I have the following two fields that need to be displayed in a table. Upon using the following statement I get the necessary info(2nd picture) but the two characters I specified can change (_CparDu,_ZfvvFH). On the 3rd line you see I need to display both high and low as it is a checkbox option.

if(Type='checkbox',PurgeChar(PurgeChar(PurgeChar(Answer,'"'),'_CparDu'),'_ZfvvFH')

Please Help

Re: Data Clean Up

MarcoWedel — Fri, 19 Dec 2014 01:02:09 GMT

Hi,

one solution could be:

Replace(Trim(If(WildMatch(Answer,'*Low*'),'Low ')&If(WildMatch(Answer,'*High*'),'High')),' ',',')

hope this helps

regards

Marco

Re: Data Clean Up

Mon, 22 Dec 2014 01:45:52 GMT

Thank you MarcoWedel

Re: Data Clean Up

MarcoWedel — Mon, 22 Dec 2014 06:45:11 GMT

You're welcome

Regards

Marco