Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
munna1317
Creator II
Creator II

List Box Total

Dear All,

How to added total in List box

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

List

a1

a2

b1

b2

Now i need like

List

a1

a2

total of A

b1

b2

total of B

Please help me regarding this

Regards ,

harish

3 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

munna1317
Creator II
Creator II
Author

Dear Marcus ,

Thanks for Your replay,

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

regards,

harish

marcus_sommer
MVP & Luminary
MVP & Luminary

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