Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have 1 table with 4 columns to reflect. hierarchy of the columns should be the same below.
Account Group | Agent | Account Type | Account Code |
---|---|---|---|
TMP | John Smith | Property | GDS-RQ-4563 |
so if i filtered TMP, dashboard should look like this.
TMP
--> John Smith
--> Property
--> GDS-RQ-4563
Try like this:
Table1:
Hierarchy([Account Group],Agent,[Account Type],[Account Code])
OR
ORG_TABLE:
LOAD * INLINE [
RegionName, StateName, CityName
NORTH, Delhi, Delhi
NORTH, Haryana, Gurgaon
SOUTH, PONDICHERRY, Pondicherry
SOUTH, TAMIL NADU, Chennai
SOUTH, TAMIL NADU, Villupuram
WEST, GUJARAT, Surat
WEST, Maharashtra, Kalyan-Dombivli (M Corp.)
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;
if this is for qlikview then perhaps use hierarchy in the file wizard ... just a suggestion.
Hi,
one solution might be:
table1:
LOAD RecNo() as ID, * FROM [https://community.qlik.com/thread/309972] (html, codepage is 1252, embedded labels, table is @1);
tabHierarchy:
LOAD ID,
Left(Hierarchy,Index(Hierarchy&'/','/',IterNo())-1) as Hierarchy
While IterNo() <= 4;
LOAD ID,
[Account Group]&'/'&Agent&'/'&[Account Type]&'/'&[Account Code] as Hierarchy
Resident table1;
hope this helps
regards
Marco
Hello Everyone,
i would like to apologize first for not introducing myself and would like to thank everyone who replied in my question.
My name is mike and i am a systems administrator mostly handling databases of our company. Our main goal is to find a solution that can replace one of our Oracle Databases which is our reporting DB. Our ReportingDB's current function is to create tables and reports from our Production Database during off peak hours to reduce the workload of the production database during peak hours. I was given the task to evaluate QLIK and is currently studying the system if indeed can replace our ReportingDB.
I have to apologies again as i cannot understand yet all your replies and how to apply it in my Desktop installation of Qlik. It would be greatly appreciated if you could send instructions on how to apply or use your answers. marcowedel wadecapventis balabhaskarqlik
Thanks Everyone!
Regards,
Mike
hi mike,
what version of qlik are you using please?
i suggest you experiment with a pivot table.
kindly refer to this official qlik video:
https://www.youtube.com/watch?v=goVmLcvuC10
best wishes.