Change Set Analysis Expression

[#1]

HI i have the following expression;

(Sum({$<Lagernr={$(LagerNr)}>} Lagernr.Lagersaldo)

-Sum({$<OrderRad.Lagernr={$(LagerNr)}>} (-1*(mLEV_STAT-1)) * #FSG_ord_ant*mFSG)

+Sum({$<IOR.Lagernr={$(LagerNr)}>} #FSG_ord_ant * mINK * ((mLEV_STAT-1)*-1)))

*avg(Artikel.Standardkalkyl)

i wish to remove the variable and use only the field Lagernr.

i have tried with the following statement however recieve incorrect  value whereby it gives me the total of all Lagernr.

i wish only for the selected Lagernr to appear.

(Sum({$<Lagernr=>} Lagernr.Lagersaldo)

-Sum({$<OrderRad.Lagernr=>} (-1*(mLEV_STAT-1)) * #FSG_ord_ant*mFSG)

+Sum({$<IOR.Lagernr=>}

#FSG_ord_ant * mINK * ((mLEV_STAT-1)*-1)))

*avg(Artikel.Standardkalkyl)

[jonathandienst · Accepted solution]

Hi

if you want to allow the user to select a Lagernr and only display that one, just remove the

$<Lagernr=>} clause which tells Qlikview to ignore the Lagernr selection

Regards

Jonathan

[#3]

Hi Jonathan!

thanks for your reply.

my issue in this case is that the Lagernr (Eng Trans. Warehouse nr) must match with different row types.

for example -> IOR.Lagernr  = the selected Lagernr (example 2000) and OrderRad.Lagernr = the selected Lagernr (2000)

that is what i am trying to achieve.

i have also tried with the if clause, without success.

any further ideas?