topic Re: How do i create a simple dashboard in QlikView

How do i create a simple dashboard

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How do i create a simple dashboard

BalaBhaskar_Qlik — Fri, 03 Aug 2018 14:56:16 GMT

Try like this:

Table1:

Hierarchy([Account Group],Agent,[Account Type],[Account Code])

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;

Re: How do i create a simple dashboard

wade12 — Fri, 03 Aug 2018 19:54:22 GMT

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

Re: How do i create a simple dashboard

MarcoWedel — Fri, 03 Aug 2018 21:33:09 GMT

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

Re: How do i create a simple dashboard

Anonymous — Mon, 06 Aug 2018 01:19:22 GMT

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

Re: How do i create a simple dashboard

wade12 — Tue, 07 Aug 2018 09:07:37 GMT

hi mike,

what version of qlik are you using please?

Re: How do i create a simple dashboard

Anonymous — Wed, 08 Aug 2018 05:16:24 GMT

Hi wadecapventis‌,

It's Qlik Sense Desktop 12.26.1

Regards,

Mike

Re: How do i create a simple dashboard

wade12 — Thu, 09 Aug 2018 18:29:34 GMT

i suggest you experiment with a pivot table.

kindly refer to this official qlik video:

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

best wishes.