Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Variables Load through excel

Hi,

We are loading variables, through excel file. Before loading variables, we have deleted all the variables in the Variable Overview.

As we are deleting all variables, so in the excel sheet, we have also included system variables, so that those should also be created.

But when we try to reload, they are not getting created, because of which variable "HidePrefix" is also not created and we are not able to see field starting with '_' in the list of fields, unless and until we click "Show System fields".

Any idea on this, regarding system variables load through excel file.

Regards,

MK

2 Replies
Gysbert_Wassenaar

What value put you in the cell in the excel file for the HidePrefix variable? And do you use SET or LET? If I use LET I have to use ''_' as value in Excel since Excel considers the first single quote as an indicator the cell contains text.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Thanks gwassenaar