How do i create a simple dashboard

[Anonymous]

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

[balabhaskarqlik]

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;

[wade12]

if this is for qlikview then perhaps use hierarchy in the file wizard ... just a suggestion.

[MarcoWedel]

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

[Anonymous]

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

[wade12]

hi mike,

what version of qlik are you using please?

[Anonymous]

Hi wadecapventis‌,

It's Qlik Sense Desktop 12.26.1

Regards,

Mike

[wade12]

i suggest you experiment with a pivot table.

kindly refer to this official qlik video:

https://www.youtube.com/watch?v=goVmLcvuC10

best wishes.