Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vireshkolagimat
Creator III
Creator III

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
settu_periasamy
Master III
Master III

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
Specialist II
Specialist II

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
Creator III
Creator III
Author

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
Specialist II
Specialist II

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