topic Re: No one answer yet ? in QlikView

No one answer yet ?

Fri, 10 Oct 2014 13:04:02 GMT

if(index(Code, ' '), concat(left(Test, 1) & '(' & len(Test) & ')', ' ', Row), concat(left(Test, 1) & '(' & len(Test) & ')', '-', Row)) as Test2

Re: No one answer yet ?

Fri, 10 Oct 2014 13:12:49 GMT

not sure why this expression is used. It checks for space in the Code field, if space presents then first letter of Test field and length of test field.

Eg: if Code = 'Country' and Test='India' then result would be

I(5)-

this will be repeated for total nyumber of occurences of India in data.

If India exists 5 times

I(5)-I(5)-I(5)-I(5)-I(5)

Re: No one answer yet ?

Peter_Cammaert — Fri, 10 Oct 2014 13:17:51 GMT

What exactly was your question?

Re: No one answer yet ?

Fri, 10 Oct 2014 13:54:36 GMT

explination of above expression how it works