topic Hierarchy in QlikView

Hierarchy

sat_tok52 — Thu, 21 May 2015 18:08:29 GMT

Hi All,

As per my requirement ,I have to create hierarchy and I tired with some qlikview community examples but I didn't get the answer.

My hierarchy Should Show like Region /Product Category /Product Sub Category.

Please any one help me.

LOAD [Row ID],

[Order Priority],

Discount,

[Unit Price],

[Shipping Cost],

[Customer ID],

[Customer Name],

[Ship Mode],

[Customer Segment],

[Product Category],

[Product Sub-Category],

[Product Container],

[Product Name],

[Product Base Margin],

Region,

[State or Province],

City,

[Postal Code],

[Order Date],

[Ship Date],

Profit,

[Quantity ordered new],

Sales,

[Order ID]

FROM

Thanks,

Sateesh.T

Re: Hierarchy

Anonymous — Thu, 21 May 2015 20:00:48 GMT

I reckon there are 2 seperate hierarchies

[Product Category],

[Product Sub-Category],

[Product Container],

[Product Name],

and

Region,

[State or Province],

City,

[Postal Code],

You can leave the table as it is and they both should do fine as a couple of Drill Down Groups..

Re: Hierarchy

petter — Thu, 21 May 2015 20:15:12 GMT

Do you want your hierarchy displayed in a List Box or in a Pivot Table?

Re: Hierarchy

petter — Thu, 21 May 2015 20:18:33 GMT

In a List Box you can make the hierarchy like this:

- Create an Expression instead of selecting a single field by using this expression:

Region & '/' & [Product Category] & '/' & [Product Sub-Category]

and then select the check-box at the bottom of the GENERAL tab in List Box properties and

the standard "With Separator" is set to / already.

Re: Hierarchy

sat_tok52 — Fri, 22 May 2015 13:25:56 GMT

Both List box and Pivot Table