Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Summing up sub-levels in List box TreeView

I formed a hierarcy using List box TreeView. I want all sub-levels to be summed up (like a pivot table does.) So for 'small' under 'Abrand' I need to see 55. And same for all above and below.  sum(cost) doesnt work!


LOAD * Inline [
Product, cost
Abrand-smdll-salty, 19
Abrand-small-salty, 23
Abrand-small-sweet, 22
Abrand-large-sweet, 12
Bbrand-smdll-salty, 33
Bbrand-small-salty, 23
Bbrand-small-sweet, 43
Bbrand-large-sweet, 65

]
;

treeview_sum.PNG

1 Reply
Highlighted
Contributor II
Contributor II

Re: Summing up sub-levels in List box TreeView

I became convined that this is not possible using Listbox TreeView.  here is my logic:  its not possible to differenciate between hierarchy levels in expression ( treeView actually doesn't build a hierarchy - its  only seperaying text based on delimiters.)

hierarchy() function and pivot tables solved my problem.