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..
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.
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.
