topic Re: Division function in QlikView

Division function

vikas_nandanwar — Wed, 26 Apr 2017 08:47:49 GMT

Hi,

I have below columns -

CTS

CostPerCts

value

ExpPrfi%

Profit

Brokerage

I want a calculated field to be joined at the right of the column as

WT% =Profit/CTS

How to do this?

Script for division function and Joining function

Please help

Re: Division function

Anil_Babu_Samineni — Wed, 26 Apr 2017 10:34:10 GMT

May be this?

Sample:

Load CTS,

CostPerCts,

value,

ExpPrfi%,

Profit,

Brokerage

From <Data Source>;

Right Join (Sample)

Load *, Profit / CTS as WT%;

Resident Sample;

Re: Division function

sunny_talwar — Wed, 26 Apr 2017 10:42:54 GMT

Why do you need a join Anil? Why not just this

Sample:

Load CTS,

CostPerCts,

value,

ExpPrfi%,

Profit,

Brokerage,

Profit / CTS as WT%

From <Data Source>;

Re: Division function

Anil_Babu_Samineni — Wed, 26 Apr 2017 10:47:47 GMT

Yes, We can go same way. But, He mentioned one sentence over post. So that i came to know may be require Right Outer Join

Re: Division function

sunny_talwar — Wed, 26 Apr 2017 10:52:14 GMT

I don't really understand what OP wants, but for what you have provided, I will not create a right join, but rather just create the new field in the same load.... Having said that, I don't really know the requirement....so you might be right

Re: Division function

awhitfield — Wed, 26 Apr 2017 11:51:17 GMT

Hi I am with sunny here, in this case I think 'joined' means 'added'

Andy

Re: Division function

vikas_nandanwar — Wed, 10 May 2017 04:07:08 GMT

Done Thanks for the help