topic Re: List Box Total in QlikView

List Box Total

munna1317 — Mon, 26 Jan 2026 18:19:17 GMT

Dear All,

How to added total in List box

For example, we have Value in List box like Below.

List

Now i need like

List

total of A

total of B

Please help me regarding this

Regards ,

harish

Re: List Box Total

marcus_sommer — Thu, 07 Jun 2018 06:42:08 GMT

The listbox is not designed for such a task but pivot-charts are. Just create a main-category to your sub-category field within the script and then using both fields as dimensions with partial sums and an appropriate expression to them will serve your task.

- Marcus

Re: List Box Total

munna1317 — Thu, 07 Jun 2018 06:52:56 GMT

Dear Marcus ,

Thanks for Your replay,

There only one field , how to have these above totals in Pivot. any idea ??

regards,

harish

Re: List Box Total

marcus_sommer — Thu, 07 Jun 2018 07:04:07 GMT

You could use something like: left(List, 1) as a calculated dimension and List as second dimension within the pivot. But like above mentioned it's often better (by large datasets, multiple use of the logic, need to apply aggr() functions and/or TOTAL statements within expressions and so on) to do such categorizing within the script.

- Marcus