Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sat_tok52
Creator
Creator

Hierarchy

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

4 Replies
Anonymous
Not applicable

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..

petter
Partner - Champion III
Partner - Champion III

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

petter
Partner - Champion III
Partner - Champion III

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.



sat_tok52
Creator
Creator
Author

Both List box and Pivot Table