Qlikview Beginner

[#1]

hi,

Im new to qlikview and i'm trying to create a list box that shows the list of phone numbers i have in my database but it keeps showing me this error. is it from my database or qlikview and how can i solve it ..i only want the phone numbers i.e the value

[Anonymous]

Hi Ben,

I think the problem is how you load the data to QV. Can you please attach your script code?

Elena

[Mark_Little]

Hi,

A list box will just show you the data in the field, unless you have used the expression.

Could you supply a little more info?

Mark

[r3iuk]

Can you post the loading script?  Also where is the data being loaded from (e.g. excel or csv file, of from a database connection)?

[#5]

the data is being loaded from a connection (sqlexpress) all i had to was select the table and the fields are automatically generated from the database...the only issue is everything works fine except for this particular field

[imhappiee]

Hi Ben Kel,

You can use Sub field to get this. try the below way, let me know if you  need further help.

data:

LOAD * INLINE [

    Set

    [{"Anand":"Mobile":"Value":"878418484"}]

    [{"Arun":"Mobile":"12":"7976545618"}]

];

datacheck:

Load Set,

Subfield(Set,'"',8)as mobile

Resident data;

drop table data;

exit script;

Anand

[marcus_sommer]

There are several different values included in one column. You could split them within the load with subfield() or various string-functions if you need all of these values.

If you only need the number from them you could load this field with keepchar:

Load

     ...

     keepchar(CustomData, '0123456789') as PhoneNumber

     ...

- Marcus

[awhitfield]

HI Ben,

you need to post an example app!

Andy