Field Data

[#1]

Hi all,

What is 'Field Data' option in Qlikview?

Thanks in advance

[marcus_sommer]

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

- Marcus

[#3]

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

[#4]

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.

[#5]

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.

[ganeshreddy]

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

[Kushal_Chawda]

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

of an already loaded field.

-From QlikView Reference Manual

[marcus_sommer]

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

[#9]

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.

[ganeshreddy]

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