Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Add calculated field in the load script


Hi All

In the load script of the qv file (in attachment) I want to add a new calculated field

NetWorkDays

([Datum 1: Lancering Workflow],[Datum 7: Finale goedkeuring],) as [Doorlooptijd in werkdagen (etappe)]

,'##,00',

During the reload I got the message : Field names must be unique within table MainTable:

I don't see the problem.

Can somebody help me ?

Qv in attachment.

Thanks in advance

Marc

6 Replies
MVP & Luminary
MVP & Luminary

Re: Add calculated field in the load script

NetWorkDays(1,2,) as [Doorlooptijd in werkdagen],'##,00',

The problem is the bold part. That creates a field with the name '##,00'. Since that happens twice in the load statement you get the duplicate field error. I have no idea what you intended that '##,00' to do, but it doesn't do anything useful and is causing the error you see.


talk is cheap, supply exceeds demand
Not applicable

Re: Add calculated field in the load script

Hi Marc,

Unable to open the file, will u pls provide some sample data.

Thank you

Regards,

Sub2u.

Not applicable

Re: Add calculated field in the load script

Hi

Problem is in the mean while solved by Gysbert Wassenaar.

Problem was:

The problem is the bold part. That creates a field with the name '##,00'. Since that happens twice in the load statement you get the duplicate field error.

Thanks a lot.

Merry Chrsitmas and Happy New Year.

Marc

Not applicable

Re: Add calculated field in the load script

Hello Gysbert

Thanks a lot. Indead '##,00', is useless.

Is removed and OK.

Merry Chrsitmas and Happy New Year.

Grt

Mar

MVP & Luminary
MVP & Luminary

Re: Add calculated field in the load script

Merry Chrsitmas and Happy New Year to you too!


Can you mark this discussion as Answered?


talk is cheap, supply exceeds demand
Not applicable

Re: Add calculated field in the load script

Hi Gysbert

Ok. Normally I can mark the response as “Juiste oplossing” but this is not available.

How can I mark this discussion as answered ?

Thanks a lot.

Marc