topic Re: Uploading excel spreadsheets and displaying data values in QlikView

Uploading excel spreadsheets and displaying data values

Anonymous — Thu, 18 Sep 2014 14:57:05 GMT

Hi, I've uploaded (so far) 2 excel spreadsheets and the data files contain the same set of columns. I've added a list box and it displays some of the values twice because one of the values is not capitalized. How do I make it the same? For example, one spreadsheet uses "In Progress" and the other spreadsheet uses "In progress." I want it to know it means the same thing. I'm sure I'll run into this as I keep loading more excel spreadsheets.

Thank you.

Re: Uploading excel spreadsheets and displaying data values

Anonymous — Thu, 18 Sep 2014 15:02:01 GMT

you can use uppercase(yourfield) or lowercase(yourfield), whatever you prefer for upper case or lower case characters

then all your data will look like this

is it what you want?

Re: Uploading excel spreadsheets and displaying data values

vijay_iitkgp — Thu, 18 Sep 2014 15:02:45 GMT

Hi, You can use Function Capitalize(Fildname) also you can use Upper() to make field in Upper case . Hope this help.

Re: Uploading excel spreadsheets and displaying data values

Anonymous — Thu, 18 Sep 2014 15:06:03 GMT

Yes Rudolf. Thanks guys. Sorry I'm still new to this, but is the function added in the script in the load or in the list box properties?

Re: Uploading excel spreadsheets and displaying data values

vijay_iitkgp — Thu, 18 Sep 2014 15:06:40 GMT

Please use in Script

Re: Uploading excel spreadsheets and displaying data values

Anonymous — Thu, 18 Sep 2014 15:11:28 GMT

i would prefer in script, then its done only once and not each time when you openthe listbox

Re: Uploading excel spreadsheets and displaying data values

Anonymous — Thu, 18 Sep 2014 15:23:39 GMT

what if there were values such as Planning and Planning (xyz)? How do I upload the column and then add something that anything that starts with Planning really means Planning?

Re: Uploading excel spreadsheets and displaying data values

Anonymous — Thu, 18 Sep 2014 15:29:51 GMT

there are several string functions which you can use

it depends what identifies your values

in your example it could be the string before the first space

you need to find something common for all values

or if there are only a few values you can build an inline table where you define your values

Test:

Load * Inline [

Val1, Val2

Plan, Planning

Plan, Planning (xyz)

]

and you do a left join to get the unique identifier

I would not suggest this way as it might be much work