Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vireshkolagimat
Contributor II

how to handle hierarchy in excel sheet

Hi team,

I have below data which needs to bring into QV but if you look at first column, it contains hierarchical data that is APJ region contain India , Aus etc countreis but in NA i dont have the same structure.

Need your help on this. Thank you.

Regards,

Viresh

  

Sales20102011
APJ1010
       India22
      Aus44
      China22
      Japan22
USA1212
EMEA1214
      UK33
     Germany33
     Italy66
    France02
Total3436
4 Replies

Re: how to handle hierarchy in excel sheet

Hi Viresh,

How do we identify which one is Hierarchy (Region) which one is non-hierarchy (Country) ? do you have any specific code?

May be you can create one inline table with Region only. Then you can match with your table, If it matched, then you can just assign, it is Hierarchy otherwise non-hierarchy..

pradeepreddy
Valued Contributor II

Re: how to handle hierarchy in excel sheet

See the attachment, IT might be helpful for you..

I have taken a space before to the country filed, to separate it from the Region..

vireshkolagimat
Contributor II

Re: how to handle hierarchy in excel sheet

Hi, if i select APJ, i am not able to see the countries which comes under APJ ( India , Aus, China, japan).

Here Region and country information is available in single column, In my case APJ, USA and EMEA are the regions.

Regards,

Viresh

pradeepreddy
Valued Contributor II

Re: how to handle hierarchy in excel sheet

See the bellow image... you can remove the regions(APJ,EMEA,USA) from the Country field..  If this is not suitable, can you elaborate your requirement..

Test.png

Community Browser