Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Variables Load through excel


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.



2 Replies
MVP & Luminary
MVP & Luminary

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
Creator II
Creator II

Thanks gwassenaar