Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change Set Analysis Expression

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)

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Change Set Analysis Expression

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: Change Set Analysis Expression

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Highlighted
Not applicable

Re: Change Set Analysis Expression

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?