topic Re: Field Data in QlikView

Field Data

Fri, 21 Aug 2015 06:39:25 GMT

Hi all,

What is 'Field Data' option in Qlikview?

Thanks in advance

Re: Field Data

marcus_sommer — Fri, 21 Aug 2015 09:42:39 GMT

What do you mean - a bit more context will be needed.

- Marcus

Re: Field Data

Fri, 21 Aug 2015 09:46:58 GMT

If you want to load the single field single record from already loaded table fields, that toime it is used, but as of my exp i never used this option

Re: Field Data

Fri, 21 Aug 2015 12:10:13 GMT

Hi Marcus,

I was talking about the Field data option in the Tools pane, below the edit script pane in script editor window. It present in the Data tab, below Web Files option.

Re: Field Data

Fri, 21 Aug 2015 12:12:49 GMT

Hi arumamahesh,

It actually contains options for 'Local file', 'Internet file' and 'From field', So, I am not able to understand the context of these options while loading only particular fields of data.

Re: Field Data

ganeshreddy — Fri, 21 Aug 2015 12:32:29 GMT

Hi Madhura,

It is more like table files and web files option, by using field data we can also get/load field level information to script according to requirement. More over we can get/load element information. My better advice is to click on the option and explore you will get an idea.

Regards,

Ganesh

Re: Field Data

Kushal_Chawda — Fri, 21 Aug 2015 12:32:54 GMT

Opens the File Wizard: Source dialog where it is possible to load the contents

of an already loaded field.

-From QlikView Reference Manual

Re: Field Data

marcus_sommer — Fri, 21 Aug 2015 12:41:49 GMT

Unfortunately is the documentation for the different wizards very small ... I think the first both options are the same as if you used the table-wizard or the web-wizard above this button. By the third option you could load data from a field and it's a special syntax which I don't like and not really use - I prefer instaed to run a loop over the field like:

LOAD max(FieldValue('Id', recno())) AUTOGENERATE FieldValueCount('Id');

See here how it worked and which use-cases there are: “Fastest” Method to Read max(field) From a QVD | Qlikview Cookbook

- Marcus

Re: Field Data

Fri, 21 Aug 2015 12:47:07 GMT

Hi Ganesh,

Yes, I tried that and figured out the 'local file' and 'from fields' option. But then I dont find the difference in Web files and this option.

Re: Field Data

ganeshreddy — Fri, 21 Aug 2015 13:05:46 GMT

Hi Madhura,

I spotted the difference. Here local file option is similar to web files and internet file option in Field Data wizard, but 'from fields' option gives you a facility to customize/load already loaded data in QVW . I hope this helps.

Regards,

Ganesh

Re: Field Data

Sat, 22 Aug 2015 08:06:58 GMT

Hi Ganesh,

Thanks for the efforts. I am actually stuck between 'Web files' and 'Field Data' options. I cant find any difference between them.

Re: Field Data

Anonymous — Sat, 22 Aug 2015 08:15:05 GMT

Hi,

Field data: you can load specific rows coming from a field located in a database

Hope it helps!!

Re: Field Data

Anonymous — Sat, 22 Aug 2015 08:16:11 GMT

Hi,

Please go through this link for better understanding:

http://blog.dbi-services.com/qlikview-load-data-in-qlikview-qliksence-best-practice-and-trick/

Re: Field Data

Anonymous — Sat, 22 Aug 2015 08:18:32 GMT

You have 4 different options:

(1) Table Files: you can select the following kind of files

(2) QlikView File: You can load .qvw file (QlikView file)
(3) Web File: You can load a file coming from a website
(4) Field data: you can load specific rows coming from a field located in a database

Re: Field Data

Anonymous — Sat, 22 Aug 2015 08:19:26 GMT

Hi,

Web File: You can load a file coming from a website

Field data: you can load specific rows coming from a field located in a database

Re: Field Data

Tue, 25 Aug 2015 12:56:17 GMT

Thanks Ganesh, thats actually clears many things and I might surprise you with some stupid questions forth.