topic Re: Help with Variables in QlikView

Help with Variables

shree909 — Wed, 20 Mar 2013 21:13:49 GMT

Hi ,

i want to import the variables from excel file to the qlikview which is working fine .

the issue i have is whenever i want to edit or add the new variables in the excel file and try to assign the = sign before the expression in excel file the column behaves weird and written the cell number.

how to avoid this cell number when editing in the excel file.

if i get rid of = sign in expression then its not getting any error on the excel file, i can load it this way but everythime when i reload the variables form the excell file

each time i have to assighn the = sign in the expression overview to get the values get calculated..

Thanks

sree

Re: Help with Variables

Wed, 20 Mar 2013 21:31:27 GMT

If you add an equals sign at the begin of a cell in a worksheet, then excel will try to interpret it as a function. The workaround is to add a space before the equal sign. Excel will not try to calculate the cell and QlikView should still evaluate it.

Re: Help with Variables

shree909 — Wed, 20 Mar 2013 22:25:26 GMT

Thats Perfect..

Thanks