topic Re: Replace values?? in QlikView

Replace values??

qlikuser222 — Thu, 13 Jul 2017 12:43:38 GMT

Hi All,

Can anyone please help me with replacing the filed values in Elkview from the external excel file?

Please find attached QVW and excel.

PrashantSangle — Thu, 13 Jul 2017 12:47:04 GMT

There are many ways

1 : You can use apply map (for details see in help menu)

2 : join both table then take whichever column you want to display

sunny_talwar — Thu, 13 Jul 2017 13:03:54 GMT

Also look here

arvind_patil — Thu, 13 Jul 2017 13:15:33 GMT

Hi Sunny,

I agree with Prashant. With the help of apply map or join you can achieve it.

Thanks,

Arvind Patil

effinty2112 — Thu, 13 Jul 2017 13:22:14 GMT

Hi Nicholas,

Maybe the Capitalize function is what you need on this occasion?

Capitalize('APplE') = 'Apple'

cheers

Andrew

qlikuser222 — Thu, 13 Jul 2017 13:28:28 GMT

Hi,

Thanks for reply.

But in the real excel we have different names.

For example APple in qlikview but in excel its Apl.. I cant just use Capitalize.

Thanks

sunny_talwar — Thu, 13 Jul 2017 13:29:24 GMT

Is that for me or Nicholas?

qlikuser222 — Fri, 14 Jul 2017 20:32:30 GMT

Hi ,

I am unable to do it because there is no common filed between excel file and Qlikview table.

Is there another way without using apply map?

Thanks