Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Data to be loaded and saved back and loaded again from/to qvd

Hi,

in my current app, some data that is primarily forthcoming from an Excel file will be stored to qvd

=> then it will be loaded from that qvd, edited and saved back with the same name to be loaded again.

=> My issue is with fields the names of which stretch over two lines in the base_Excel. These are enclosed in square brackets if you use
      the wizard to build your LOAD and cover two lines in the script.

=> I cannot just rename any such field just like that because the next time I load that qvd, QlikView will return a "field not found" error
      regarding the original field_name. Also, I will eventually have to load a new base_Excel and compare it to the qvd I have which
      is more difficult if I have renamed any fields.

<=> When I leave it as it is and on the GUI I try to create a textbox that just shows the contents of this field - that doesn't work because
        as soon as I type an equals sign, the script_editor reports an error.

Can anyone advise me how to deal with such fields?

Thanks a lot!

Best regards,

DataNibbler

0 Replies