topic Re: Change Set Analysis Expression in QlikView

Change Set Analysis Expression

Wed, 07 Aug 2013 10:53:21 GMT

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 — Wed, 07 Aug 2013 11:36:02 GMT

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

Wed, 07 Aug 2013 11:46:30 GMT

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?