topic New to QlikCommunity - Need some help in QlikView

New to QlikCommunity - Need some help

Tue, 29 May 2012 18:16:41 GMT

Hello,

I'm a new user to QlikView and have been reviewing the Community for answers to my current issue:

I'm have a data set that has a "*" as a prefix to the data (IE: *79-XXXXX). In order for me to correctly join this with our other item fields it needs to be stripped of the "*".

My questions:

1) How do I accomplish this?

2) Where do I put this conversion in? Load script or after the data is the QVW?

Thank you-

Re: New to QlikCommunity - Need some help

swuehl — Tue, 29 May 2012 18:38:57 GMT

To allow QV to join or link the tables, you need to do this in the load script.

Maybe you could use purgechar() to get rid of the '*' (if you don't have multiple occurences of '*' later on in your field value, like *79-XXXX*Y )

LOAD

purgechar(FIELD,'*') as FIELD,

...

FROM ...

or use mid() function

LOAD

mid(FIELD,2) as FIELD,

...

FROM ...

New to QlikCommunity - Need some help

Thu, 07 Jun 2012 15:22:00 GMT

Swuehl,

The string purgechar worked. Thank you!