topic Re: Adding two fields in the script in QlikView

Adding two fields in the script

Wed, 06 Aug 2014 05:34:14 GMT

Hi there,

I have recently started using qlikview. I need some assistance. As an example, there are two fields 'Branch X' and 'Branch Z':

Branch X Branch Z

12 8

30 6

40 4

How do I add these two fields in qlikview. I know I can add these in excel and then upload it again in qlikview. But is there another way.

I tried adding the following line in the script but it didn't work:

[Branch X] + [Branch Z] as [Total Sales]

Can anyone please tell me what I am doing wrong

Your assistance will be highly appreciated.

Thanks,

Patrick

Re: Adding two fields in the script

tresB — Wed, 06 Aug 2014 05:37:55 GMT

Try like:

RangeSum([Branch X] , [Branch Z]) as [Total Sales]

Re: Adding two fields in the script

ashfaq_haseeb — Wed, 06 Aug 2014 05:38:32 GMT

Hi you can load as it is and in fron end try below

=sum([Branch X]) + sum([Branch Z])

Or in back-end try like below

Main:

LOAD *,

[Branch X]+[Branch Z] as [Total Sales];

LOAD * Inline

[

Branch X,Branch Z

12,8

30,6

40,4

]

;

Regards

ASHFAQ

Re: Adding two fields in the script

mdmukramali — Wed, 06 Aug 2014 05:40:14 GMT

Dear,

can you attach your sample file.

see the below script of sample data..

it's working fine.

Main:

LOAD * Inline

[

Branch X,Branch Z

12,8

30,6

40,4

]

;

LOAD *,

[Branch X]+[Branch Z] as [Total Sales]

Resident Main;

DROP Table Main;

Thanks,

Mukram.

Re: Adding two fields in the script

MarcoWedel — Wed, 06 Aug 2014 05:40:22 GMT

SHould work like you tried.

Please post example app / data

Re: Adding two fields in the script

amit_saini — Wed, 06 Aug 2014 05:54:26 GMT

Patrick,

Hope this attachment will help you.

Thanks,
AS

Re: Adding two fields in the script

khajafareed — Wed, 06 Aug 2014 05:58:10 GMT

try inline load

T1:

LOAD * Inline

[

Branch X,Branch Z

12,8

30,6

40,4

]

;

LOAD *,

[Branch X]+[Branch Z] as [Total Sales]

Resident T1;

DROP Table T1;

Re: Adding two fields in the script

Wed, 06 Aug 2014 06:09:50 GMT

You guys are amazing! Thanks for the prompt responses

Both of the following worked.

[Branch X]+[Branch Z] as [Total Sales]

RangeSum([Branch X] , [Branch Z]) as [Total Sales]

Don't know why at first it was not working. But all good now.

Thank you very much

Cheers

Re: Adding two fields in the script

ashfaq_haseeb — Wed, 06 Aug 2014 06:18:29 GMT

Hi Can you close this thread by marking appropriate answer.

Regards

ASHFAQ