script

[Mahamed_Qlik]

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.

[tresesco]

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);

[MayilVahanan]

Hi

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,

[Mahamed_Qlik]

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