Need help for grouping data.

[agni_gold]

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

[agni_gold]

But how can i implement , i dont know

[#3]

Hello Agnivesh,

I have looked at the  the data file you attached. It does not reflect the country breakdown structure. Any how, base don the file you posted, I built a  hierarchy. Please have a look and I hope it helps and apologies if it doesnt. If your file was structured differently, you could use the transformation tool in qlikview which will allow you to easily build the hierarchy. You might need to modify the query in case of ull values to get the correct node.

[Anonymous]

Does this give you food for thought ?

[agni_gold]

Sorry friend i have only personal edition , so i am not able to open this file , but yes it will give me food can you please share the qvs file of this . So that i can see .

Thanks

[Anonymous]

Data:

load

  1 as Count ,

  if ( not isnull( [Child Description4] ) ,

  [Parent Description] & '/' & [Child Description1] & '/' & [Child Description2] & '/' & [Child Description3] & '/' & [Child Description4] ,

  if ( not isnull( [Child Description3] ) ,

  [Parent Description] & '/' & [Child Description1] & '/' & [Child Description2] & '/' & [Child Description3] ,

  if ( not isnull( [Child Description2] ) ,

  [Parent Description] & '/' & [Child Description1] & '/' & [Child Description2]  ,

  if ( not isnull( [Child Description1] ) ,

  [Parent Description] & '/' & [Child Description1] ,

  if ( not isnull( [Parent Description] ) ,

  [Parent Description]  ) ) ) ) )

  as Tree ,

  *

;

LOAD [HFM Account Parent],

    [Parent Description],

    Child1,

    [Child Description1],

    Child2,

    [Child Description2],

    Child3,

    [Child Description3],

    Child4,

    [Child Description4]

FROM

(ooxml, embedded labels, table is Hirerchy);

Then you can make a List Box Object on Tree and on the General tab <tick> Show as Tree View.

[agni_gold]

Thanks friend , but this will not work on pivot table or any table type object . This can only be used as individual field. Am i right

[agni_gold]

It comes like this

But i want Tree column should be like this

When i drill down it should be in Tree column and expand as per hierarchy.

[Anonymous]

Have you tried creating a List Box Object on field Tree and then on the General tab <tick> Show as Tree View.  It should look just like your example of what you are after.

[agni_gold]

Yes i have tried , but what exactly i want is , I want to make the Pivot table in which Hierarchy should be in single column . like this

[agni_gold]

i got this image in one of the blog

https://community.qlik.com/blogs/qlikviewdesignblog/2013/11/11/unbalanced-n-level-hierarchies