Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulberendts
Contributor
Contributor

show expressions of not selected values in listbox

in a list box, i can add an expression to a selection field. If i select a value of that field only the expression for the selected valueis shown. How can I also show the expressions for the not-selected values?

1 Solution

Accepted Solutions
effinty2112
Master
Master

Hi Paul,

If your expression is

sum(amount)

Then change it to:

sum({1} amount)

Cheers

Andrew

View solution in original post

2 Replies
effinty2112
Master
Master

Hi Paul,

If your expression is

sum(amount)

Then change it to:

sum({1} amount)

Cheers

Andrew

krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi,

Try with E() function to get the excluded values.

Check the post for more details P() & E() and where do you use them?