topic Creating a field in the script in QlikView

Creating a field in the script

Fri, 06 Sep 2013 12:44:28 GMT

We are trying to create a field name "PREMIUM" in our script using the following formula:

if (AmountType = 'P' , SignedAmount) as PREMIUM

When reloading the script there are no errors however when trying to load the field PREMIUM in a table or chart this field is not showing.

Any ideas?

Thanks.

Re: Creating a field in the script

tresB — Fri, 06 Sep 2013 13:00:25 GMT

It looks fine, please check the data.

Re: Creating a field in the script

Vegar — Fri, 06 Sep 2013 13:14:15 GMT

Check if your logical statement is correct by adding two more columns.

LOAD

[whaterverfields your are using],

if (AmountType = 'P' , SignedAmount) as PREMIUM,

if (AmountType = 'P' , SignedAmount, -1 ) as PREMIUM_TEST,

AmountType = 'P' as _AmountIsP

Resident

[Your source]

Re: Creating a field in the script

awqvuserneo — Sat, 07 Sep 2013 15:28:07 GMT

Hi Marcon,

After you load the script, try to see whether the data is properly populated via Table Viewer (CTRL+T) .

If the field and the data is okay, then what's your expression look like?

Try: Sum(PREMIUM)

Best,

Anton

Re: Creating a field in the script

Wed, 11 Sep 2013 06:42:47 GMT

Thank you all for you responses. It's now working.

Re: Creating a field in the script

Vegar — Wed, 11 Sep 2013 07:04:42 GMT

Sounds great.

A tip: you should mark the question as answered. So that future problem seekers will know it is solved and future problem solvers don't need to open it for trying to help.