topic Re: datatype issue in QlikView

datatype issue

Anonymous — Thu, 09 Jul 2015 23:25:47 GMT

Hi I have filed global, by datatype its showing as text in table viewer but data in it is numeric. so when I'm trying to use section by using left function its not working ..could someone please help me to resolve this.

John

Re: datatype issue

sunny_talwar — Thu, 09 Jul 2015 23:30:50 GMT

Can you share a sample within the field you are talking about?? You might be able to fix it using Num#() function, but to give you more detailed answer you will have to share some sample data.

Best,

Sunny

Re: datatype issue

Anonymous — Thu, 09 Jul 2015 23:43:37 GMT

Hi Sunny,

let me put it in detail here, I'm trying to apply section access using Filed called global with values

Global

10000.111

10101.101

10023.11

100003.23

when I use left(global, 3) as sectionAccess left(global, 4) as sectionAccess and upper(global) as sectionAccess.

only the values of upper(global) is being accessed.

here the dataype of global field is text but the data is numeric, how do we go for left or right function in this case

John

Re: datatype issue

sunny_talwar — Thu, 09 Jul 2015 23:52:53 GMT

What happens if you use it like this:

Upper(Left(global, 3)) as sectionAccess or Upper(Left(global, 4)) as sectionAccess

Not an expert with Section Access, so I might not be giving you a solution you are expecting, but I definitely going to learn something new while contributing here

Best,

Sunny

Re: datatype issue

Anonymous — Thu, 09 Jul 2015 23:57:11 GMT

sry Sunny , actually i missed in the above post, i used upper in all the cases, but only upper(global) is getting selected where as others Upper(Left(global, 3)) & Upper(Left(global, 4)) were being greyed out.