topic script in Management & Governance

script

Mahamed_Qlik — Thu, 05 Aug 2021 04:36:42 GMT

Hi Expert,

Need quick help:

I have table with below fields :

Division	Flag	Value
ALPHA	A	1000
ALPHA	B	100
BETA	A	2000
BETA	B	200
GAMMA	A	3000
GAMMA	B	300

I want one resulting column which should be calculated as "A-B"

Division	ResultingValue
ALPHA	900
BETA	1800
GAMMA	2700

Kindly help.

Re: script

tresB — Thu, 05 Aug 2021 05:34:40 GMT

One quick solution could be like:

Load
Division,
Sum(If(Flag='A', Value,0)-If(Flag='B', Value,0)) as ResultingValue
Group By Division;
Load * Inline [
Division Flag Value
ALPHA A 1000
ALPHA B 100
BETA A 2000
BETA B 200
GAMMA A 3000
GAMMA B 300] (delimiter is spaces);

Re: script

MayilVahanan — Thu, 05 Aug 2021 06:16:59 GMT

Try like below

Load *, If(Flag='B', -Value, Value) as RV Inline [
Division Flag Value
ALPHA A 1000
ALPHA B 100
BETA A 2000
BETA B 200
GAMMA A 3000
GAMMA B 300] (delimiter is spaces);

In Front end,

Re: script

Mahamed_Qlik — Thu, 05 Aug 2021 08:10:30 GMT

Thanks for response but Division is not only one dimensions, I have given example here
I have list of dimensions too