topic Re: Subtraction in QlikView

Subtraction

amita1621 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a query in qlikview , i have attached a image file where in i have 2 columns flag and amount, i need to subtract Gross-RI in qlikview in table , how to use that.

Re: Subtraction

rwunderlich — Wed, 24 Jan 2018 21:04:49 GMT

Sum({<Flag={'Gros'}>} Amount) - Sum({<Flag={'RI'}>} Amount)

-Rob

Re: Subtraction

maxgro — Wed, 24 Jan 2018 21:23:15 GMT

maybe this expression

if(Dimensionality()=0, sum({$ <Flag*={Gross}>} Amount) - sum({$ <Flag*={RI}>} Amount), sum(Amount))

Re: Subtraction

maxgro — Wed, 24 Jan 2018 21:26:32 GMT

load *, rowno() as id inline [

Flag, Amount

Gross,34

Gross,21

RI,12

RI,34

RI,23

];

Link:

LOAD

id,

Flag as NewFlag,

1 as PM

Resident S;

Concatenate(Link) LOAD

id,

'Net' as NewFlag,

if(Flag = 'Gross', 1, -1) as PM

Resident S;

Dimension NewFlag

Expression sum(Amount * PM)

Re: Subtraction

amita1621 — Thu, 25 Jan 2018 06:01:24 GMT

Thanks