topic Re: Hierarchy Vs Text in QlikView

Hierarchy Vs Text

vishnumusani — Mon, 16 Nov 2015 15:30:23 GMT

HI,

I have 3 tables namely as below. I want build a hierarchy model but here Hierarchy Data and its text data both are time dependent. I am able to achieve Time dependency between Hierarchy & Transaction table but not able to do same thing with its Text table to get its text information.

Transaction:

Date Key Count

01-01-2015 M1 4

01-12-2014 M1 6

Hierarchy:

Hier From To

M1 1-12-2014 31-12-2014

M1 1-01-2015 31-01-2015

hierarchyText

Hier From To Name

M1 1-12-2014 31-12-2014 N1

M1 1-01-2015 31-01-2015 N2

Could anyone please help me on this.

Thanks,

Vishnu

Re: Hierarchy Vs Text

settu_periasamy — Mon, 16 Nov 2015 16:55:00 GMT

Can you give the expected Output?

Do you mean "Hierarchy Text " table contains the text information?

if so, you can convert your From and To Field to Date field, right?

Date(Date#(From,'DD-MM-YYYY)) as From,

Date(Date#(To,'DD-MM-YYYY')) as To

Re: Hierarchy Vs Text

vishnumusani — Tue, 17 Nov 2015 03:58:20 GMT

Transaction table consists of transaction data.

Hierarchy table consists of multiple hierarchies which are going to be varied with respect to time

Text table consists of text information of those hierarchies which are also going to vary based upon time

Expected Output

For a particular month we need to build a tree hierarchy and we need to get the text information for all those tree hierarchies

if i select Jan Month Hier name should come as "N2" If its december it should be "N2" like this it needs to happen for entire hierarchy structure based upon the month selected.

Node1	Node2	Node3	No Of Emp
ROOT	Hier	Hier1	42
		Hier2	6
		Hier3	3
		Hier4	6
		Hier5	6
		Hier6	3

Thanks,

Vishnu.