topic Re: Simple Script with SET keyword in QlikView

Simple Script with SET keyword

Mon, 10 Oct 2011 05:40:56 GMT

Hi ,

can anyone tell what is the error with the following script.I am not getting the expected result..

SET currentYear=2002;

Budget:

LOAD Office,

Year,

[Budget rev.],

[Budget cost],

[Actual rev.],

[Actual cost]

FROM D:\Applns\Soumya\Qlikview\Qlikview_practices\xls-qlk\Budget.xls (biff, embedded labels, table is Sheet1$);

Budget_new:

LOAD Office,[Budget rev.],Year RESIDENT Budget where Year=$(currentYear);

Thanks in advance

Re: Simple Script with SET keyword

its_anandrjs — Mon, 10 Oct 2011 06:02:08 GMT

Hi,

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;

Rgds

Anand

Simple Script with SET keyword

SunilChauhan — Mon, 10 Oct 2011 06:07:04 GMT

check this

SET currentYear=2002;

Budget:

LOAD Office,

Year,

[Budget rev.],

[Budget cost],

[Actual rev.],

[Actual cost]

FROM D:\Applns\Soumya\Qlikview\Qlikview_practices\xls-qlk\Budget.xls (biff, embedded labels, table is Sheet1$);

Budget_new:

LOAD Office,[Budget rev.],Year RESIDENT Budget where Year='$(currentYear)';

Re: Simple Script with SET keyword

its_anandrjs — Mon, 10 Oct 2011 06:10:25 GMT

Hi,

See the attched sample file

Rgds

Anand

Simple Script with SET keyword

kaushiknsolanki — Mon, 10 Oct 2011 06:12:55 GMT

HI,

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.

Regards,

Kaushik Solanki

Re: Simple Script with SET keyword

Mon, 10 Oct 2011 06:26:55 GMT

Hi,

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.

Regards,

GJ.

Simple Script with SET keyword

Mon, 10 Oct 2011 06:39:30 GMT

Thank you very much anand..Got thre result..

Re: Simple Script with SET keyword

its_anandrjs — Mon, 10 Oct 2011 09:22:21 GMT

Hi,

Thanks I am glad to help you.

Rgds

Anand