Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

hierarchy in table

Hi I am trying to implement a requirement where i have to show a hierarchy of sales rep in a table chart.

My requirement is if someone logs in then he will be able to view a summary of people above him and one level below him.

For example:if district sales manager logs in he will see a summary of people above him and details of level below him

Geography                      |                    Sales |

National sales manager    |               12000000|

Regional sales manager   |                   400000|

Districe sales manager    |                     50000|

territory1                         |                       400|

territory2                        |                         500|

if i select territory1 then it should show me the details of territory1 in the following way:

Geography                      |                    Sales |

National sales manager    |               12000000|

Regional sales manager   |                   400000|

Districe sales manager    |                     50000|

territory1                         |                       400|

the user can drill up to go back to the initial view.

how can i implement this?

1 Reply
Not applicable

hierarchy in table

Hello,

do you have a different column for every level of the hierarchy? (such as columns named National_sales_manager, Regional_sales_manager... Territory and the value of Territory are territory1, territory2 etc).

If yes, you can create a pivot table and put every column in a different column of the pivot table respecting your hierarchy. The pivot will give you the function to drill up or down.

Now if you want to hide the descendants (for example if you select a sales manager and you don't want to see the territory) you need to play with the "enable condictional" function (on dimension tab of properties)

Regards,

Daniele