Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Expression Set Analysis

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

1 Solution

Accepted Solutions
er_mohit
Honored Contributor II

Re: Expression Set Analysis

try this

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

or this

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

2 Replies
er_mohit
Honored Contributor II

Re: Expression Set Analysis

try this

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

or this

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

Not applicable

Re: Expression Set Analysis

try this

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

Community Browser