topic Re: New value as quotient of other two value in QlikView

New value as quotient of other two value

Fri, 25 Apr 2014 12:07:00 GMT

Hello everyone,

I would like to create new value of some field which is equal quotient of other two value of that field.

What I really want?

I want to make value 'PBT MARGIN' (row 53) which is quotient of value 'PBT' (row 52) and 'REVENUE' (row 11). Hope I managed to explain and hope you will help me.

Re: New value as quotient of other two value

tresB — Fri, 25 Apr 2014 12:35:19 GMT

Create these calculated accounts in the script and concaenate to the original table. Like:

Load

field1,

field2,

Accounts,

Amount

From <>;

load

field1,

field2,

'PBT Margin' as Accounts,

Sum(If(Accounts='PBT' , Amount)) /Sum(If(Accounts='REVENUE', Amount)) as Amount

From <> Where Match(Accounts, 'PBT', 'REVENUE') Group By field1, field2 ;

Re: New value as quotient of other two value

Fri, 25 Apr 2014 12:58:58 GMT

Tnx bro, you really help me.

I set first if condition and then sum of field, and QV show me error that expression is not correct and I didn't now where i make mistake.

Is where condition necessary?

Re: New value as quotient of other two value

tresB — Fri, 25 Apr 2014 13:08:22 GMT

Not necessary. But that would help you improve reload time.

Re: Re: New value as quotient of other two value

paulyeo11 — Thu, 21 Aug 2014 09:06:59 GMT

Hi Tres

I have issue on 2nd step on how to get the 2 field . see my enclosed QV doc.

Hope you can advise me .

Paul