Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

No data display

Hi all,

Marco Wedel

I have created One hierarchy..  when i came to see in the listbox  it is not showing any values in the listbox..   and it is showing hierarchy.

what might be the issue?

can anyone explain? Attached image for reference.

Best

Chanty

1 Solution

Accepted Solutions
MarcoWedel

Hi,

I guess you missed the PathSource parameter in your example resulting in a path string consisting of delimiter characters only. So one solution might be:

QlikCommunity_Thread_241063_Pic1.JPG

Data:

Hierarchy(Account, Parent, AccountName, GroupName, AccountName, LedgerPath, '|', PathDepth)

LOAD Account,

    Parent,

    Account as AccountName

Inline [

Account, Parent

Acc1, Acc1

Acc2, Acc1

Acc3, Acc1

Acc4, Acc2

Acc5, Acc2

Acc6, Acc3

Acc7, Acc4

Acc8, Acc4

Acc9, Acc6

];

hope this helps

regards

Marco

View solution in original post

6 Replies
ramasaisaksoft

Hi Chanty,

What code you had written? if you share ur code then only we will understand .else FYI..below links will help to you.

Hierarchy Issues

Hierarchies - problems with sub-trees

Hierarchy Drill Down Issue

Chanty4u
MVP
MVP
Author

thanks sai,

Below script i have used.

Data:

Anil_Babu_Samineni

Chanty Bro,

Can we know full script, What are these from your script GroupName, LedgerPath,PathDepth

OR

Try with My script and let us know if this helps with you

ORG_TABLE:

LOAD * INLINE [

    RegionName, StateName, CityName

    South, Andhra, Andhra

    South, Prakasam, Ongole

    South, Pondicherry, Pondicherry

    South, Tamil Nadu, Chennai

    South, Tamil Nadu, OMR

    North, New Delhi, Surat

    WEST, Maharashtra, Kalyan Nagar

    WEST, Maharashtra, Pune

];

ITEM:

LOAD Distinct CityName as VALUE, CityName & '-City' as NODE_ID, StateName & '-State' as PARENT_NODE_ID resident ORG_TABLE;

LOAD Distinct StateName as VALUE,StateName & '-State' as NODE_ID, RegionName & '-Region' as PARENT_NODE_ID resident ORG_TABLE;

LOAD Distinct RegionName as VALUE,RegionName & '-Region' as NODE_ID,  RegionName & '-Region' as PARENT_NODE_ID resident ORG_TABLE;

HIERARCHY_TABLE:

Hierarchy(NODE_ID_H,PARENT_NODE_ID_H, ID, PARENT_NAME, NAME, NAME_FOR_TREE) load

NODE_ID,

NODE_ID as NODE_ID_H,

PARENT_NODE_ID as PARENT_NODE_ID_H,

VALUE as ID,

VALUE as NAME

resident ITEM;


Output seems this, Try from your end like below and let us know your script so that we may can help with you


Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MarcoWedel

Hi,

I guess you missed the PathSource parameter in your example resulting in a path string consisting of delimiter characters only. So one solution might be:

QlikCommunity_Thread_241063_Pic1.JPG

Data:

Hierarchy(Account, Parent, AccountName, GroupName, AccountName, LedgerPath, '|', PathDepth)

LOAD Account,

    Parent,

    Account as AccountName

Inline [

Account, Parent

Acc1, Acc1

Acc2, Acc1

Acc3, Acc1

Acc4, Acc2

Acc5, Acc2

Acc6, Acc3

Acc7, Acc4

Acc8, Acc4

Acc9, Acc6

];

hope this helps

regards

Marco

View solution in original post

MarcoWedel

Glad you liked some answers.

Please also close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

Chanty4u
MVP
MVP
Author

Nice Macro it worked like as a champ