Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
Do you want your hierarchy displayed in a List Box or in a Pivot Table?
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.
Both List box and Pivot Table