topic Multiple value names for the one value in QlikView

Multiple value names for the one value

Thu, 20 Jan 2011 18:04:17 GMT

Hi all, long time reader, first time poster!

I am building a simple Qlikview application at the moment, the source data is a single excel file and all the data resides in one table.

Unfortunately the data itself is quite messy. One problem I am encountering (I foresee many more!) at the moment is in the "Country" field. There has been no standardized data entry protocol, so for each country (e.g. Spain) I have multiple codes (e.g. ES, es, Spain).

I'm looking for a tidy solution to this problem. IF statements? Mapping tables?

Thanks in advance,

Michael

Multiple value names for the one value

Thu, 20 Jan 2011 18:55:00 GMT

If you had another table linked with country table, then you could use distinct... But this seems not the case. I'm trying to do something to help you, if I find the solution I'll post here.

Multiple value names for the one value

Thu, 20 Jan 2011 19:05:16 GMT

You could try something like this:

if([Country] = 'ES' or [Country] = 'e.g. ES' or [Country] = 'es' or [Country] = 'e.g Spain', 'Spain')

It's the easyest way that I found, on the other hand, it just work if the data is not so high.

Multiple value names for the one value

Thu, 20 Jan 2011 19:05:49 GMT

Hi Michael,

Better using mapping table.

Regards,

Srinivasan

Multiple value names for the one value

Fri, 21 Jan 2011 11:39:19 GMT

Many thanks guys!