topic Re: Variables Load through excel in QlikView

Variables Load through excel

Anonymous — Mon, 18 May 2015 06:20:19 GMT

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,

Re: Variables Load through excel

Gysbert_Wassenaar — Mon, 18 May 2015 13:30:58 GMT

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.

Re: Variables Load through excel

Anonymous — Thu, 21 May 2015 10:36:43 GMT

Thanks gwassenaar‌