Discussion Board for collaboration on QlikView Scripting.
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.
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..
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..
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.
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..