topic Re: how to insert it in script in QlikView

how to insert it in script

Fri, 01 Mar 2013 15:46:15 GMT

I have to sreate a field in qv script how to make it

if([Customer Number Act]='789QWA','DIR', null()) as D,

if([Customer Number]='9977YU','COMM', null())as C,

Re: how to insert it in script

alexandros17 — Fri, 01 Mar 2013 15:57:02 GMT

If you need a unique field the starting conditions are wrong because you can't have a field C and D together.

If you want 2 fields just write what you posted, otherwise, if you need only one field:

if([Customer Number Act]='789QWA','DIR',

if([Customer Number]='9977YU','COMM', null())

)

as C

hope it helps

Re: how to insert it in script

Fri, 01 Mar 2013 16:09:10 GMT

thanks earlier expression worked

i need one more thing that is

if([Customer Number Act]='789QWA','DIR',

if([Customer Number]='9977YU','COMM',

if([Customer Number Act]='789QWA',+if([Customer Number]='9977YU','total' null())

)

as C

dir+comm = total

how to write this one

thanks earlier expression worked

Re: how to insert it in script

alexandros17 — Fri, 01 Mar 2013 16:11:17 GMT

can you explain the expression

if([Customer Number Act]='789QWA',+if([Customer Number]='9977YU','total' null())

what does + means?

Re: how to insert it in script

Fri, 01 Mar 2013 16:14:51 GMT

here the value of the total will be the values of DIR and COMM and for that what expression should i need

and it's name should be total

Re: how to insert it in script

alexandros17 — Fri, 01 Mar 2013 16:33:15 GMT

You need another field because the same conditions should be evaluated in two different ways

add the field

if([Customer Number Act]='789QWA' or [Customer Number]='9977YU','total' null())

)

as D

Re: how to insert it in script

Fri, 01 Mar 2013 16:40:57 GMT

but i need the three fields in the same

is there any way it should show me

C D Total

i am using pivot table

Re: how to insert it in script

alexandros17 — Fri, 01 Mar 2013 16:48:11 GMT

I'm sorry but there are no ways:

the condition is on

Customer Number Act

if it's value is '789QWA' you want 'DIR'

if it's value is '9977YU' you want 'COMM'

if you add a condition on the same fields and on the same values the condition will be yet satisfyed by the previous one

Re: how to insert it in script

Fri, 01 Mar 2013 16:55:54 GMT

thanks for tha answer is there any way we can do the sum for the DIR and COMM rows and show on to the right

Re: how to insert it in script

alexandros17 — Fri, 01 Mar 2013 17:49:01 GMT

as I told you before in the script

if([Customer Number Act]='789QWA' or [Customer Number]='9977YU','total' null())

)

as D

or in an expression using a similar sysntax