topic Re: Expression Set Analysis in QlikView

Expression Set Analysis

Wed, 07 Aug 2013 07:25:40 GMT

hi i have the following expression that is attached to a variable;

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

the Variable - WarehouseVariable allows me to enter one Value ie.1000

i would like to add a listfield to my analysis now, whereby i can dynamically pass WarehouseNr to the statement.

if i do the following i recieve a list of all the Articles and it is not dynamic

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

is there a another way to write the statement?

PS i have other columns in the chart that i dont want to effect that is why i am using Set analysis.

Best,

Bradley

er_mohit — Wed, 07 Aug 2013 07:33:18 GMT

try this

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

or this

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

Wed, 07 Aug 2013 07:48:02 GMT

try this

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