Discussion board where members can get started with QlikView.
can anyone tell what is the error with the following script.I am not getting the expected result..
FROM D:\Applns\Soumya\Qlikview\Qlikview_practices\xls-qlk\Budget.xls (biff, embedded labels, table is Sheet1$);
LOAD Office,[Budget rev.],Year RESIDENT Budget where Year=$(currentYear);
Thanks in advance
Go to Solution.
See the attched sample file
Your code is correct you have to drop the table after loading resident the Budget table or in place of drop table rename the new fields in resident load then you get the new year = 2002 data as output.
drop table like
Drop Table Budget;
LOAD Office,[Budget rev.],Year RESIDENT Budget where Year='$(currentYear)';
Let me guess whats the problem you are facing. You are unable to find the table Budget_new.
If yes then let me tell you the reason. The reason is the Budget_new is having the same field name as the Budget and thats the reason qlikview just appended the Budget_New in Budget.
Please let me know if you have any other problem.
To prevent the fields from automatically concatenating when loading, you could probably use Noconcatenate Load in the Budget_New table.
Other solutions could be to drop the budget table or to rename the fields in the Budget_new table so that they do not match the fields in the Budget table.
Thank you very much anand..Got thre result..
Thanks I am glad to help you.