Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

try this

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

or this

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

View solution in original post

2 Replies
er_mohit
Master II
Master II

try this

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

or this

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

Not applicable
Author

try this

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