topic Re: List Box Values with expression in QlikView

List Box Values with expression

Wed, 25 Nov 2020 16:16:04 GMT

Dear QVExperts,

A listbox in the dashboard, displays only the expression only to the selected value.

Is it the default behaviour? Can i able to display the expression for all the values of the listbox?

Please find enclosed the Sample file.

Thanks,

Sasi

Re: List Box Values with expression

sunny_talwar — Mon, 14 Mar 2016 12:16:53 GMT

Try this expression:

=Sum({1}Sales)

Re: List Box Values with expression

Mon, 14 Mar 2016 12:19:35 GMT

Thanks a lot Sunny. It worked.

Re: List Box Values with expression

sunny_talwar — Mon, 14 Mar 2016 12:24:31 GMT

Just so you know, Sum({1} Sales) won't change based on any selection, but if you would like it to change based on certain selections such as Region or Product, you can also try using Sum({<SALESREP>} Sales) to just ignore selections in SALESREP field.

Re: List Box Values with expression

Mon, 14 Mar 2016 12:28:26 GMT

Yeah. Sure. Tried & working.