Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
meetmrudul
Contributor II

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
MVP & Luminary
MVP & Luminary

Re: Variables Load through excel

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
meetmrudul
Contributor II

Re: Variables Load through excel

Thanks gwassenaar