Solved: Need help for grouping data. - Qlik Community

agni_gold · ‎2015-05-09

I am attaching the data in excel , and i want result like attached screenshot.

I have tried many ways but not able to do this.

Please help

stigchel · ‎2015-05-09

Have you read the comments in that blog? One is from HIC explaining how he made that:

The pivot table is easy to make:

Create a pivot table with Node1..Node7 as dimensions.
Make the dimension columns narrower.
On Properties - Style, check the "Indent Mode"
Also check the "Use only first dimension label"
Uncheck "Vertical Dimension Cell Borders"
On Properties - Presentation, check the "Subtotals on Top"

Done!

HIC

View solution in original post

MarcoWedel · ‎2015-05-09

Should work with a pivot table out of the box.

Gysbert_Wassenaar · ‎2015-05-09

A single dimension column in a pivot table that expands expands like a treeview listbox is not possible in Qlikview.

talk is cheap, supply exceeds demand

agni_gold · ‎2015-05-09

is any other way to do this ?

Or what should be the data structure (in attached excel) to do this.

Gysbert_Wassenaar · ‎2015-05-09

Simply use a standard pivot table with all the levels of the hierarchy as dimensions. Expand the dimensions as needed.

Or code an alternative pivot table object as an extension object.

talk is cheap, supply exceeds demand

agni_gold · ‎2015-05-09

other than pivot table , is any other chart object can do this ? like straight table

Gysbert_Wassenaar · ‎2015-05-09

No.

talk is cheap, supply exceeds demand

agni_gold · ‎2015-05-09

This type of grouping is possible in qliksense.

agni_gold · ‎2015-05-09

Actually i saw something here

Unbalanced, n-level hierarchies

but how can i do that , i dont know.

sunny_talwar · ‎2015-05-09

There is a supporting document with the blog you shared which gives more insights on when it can be used and kind of how it can be implemented. Have you looked at that?

Hierarchies‌