Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Any Help

Hi,

I have two table,

first table is :

LOAD ID,

    Type,

    Code,

    Description

in description i have country names,zone names,region names,state names,district names,territory names,town names based on ID.

second table is :

LOAD GeoID,

    CountryID,

    ZoneID,

    RegionID,

    StateID,

    DistrictID,

    TerritoryID,

    TownID

In this table i am having only the IDs for related to first table Description.

Now i want to create the hierarchy from country name to town name.How to overcome from this problem.How to create a hierarchy

any help

Hello Kaushik,

Thanks for helping,

PFA is my first table and second table:

I want Hierarchy from Country to Town.

regards,

baru

regards,

baru

12 Replies
Not applicable
Author

Not applicable
Author

untitled.bmp

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You're in luck Henric Cronström very recently wrote a blog post about this issue. You'll probably want to read his article about generic keys as well.


talk is cheap, supply exceeds demand