Hierachy data

[#1]

Hi,

I have hierachy data that I load into my qlikview model. Eg.

                    Level1      Level2      Level3       Level4

                    Entry1

                                   Entry1.1

                                                  Entry1.1.1

                                                                  Entry1.1.1.a

                                                                  Entry1.1.1.b

                                                  Entry1.1.2

                                                                  Entry1.1.2.a

                                   Entry1.2

                                                  Entry1.2.1

                                                                  Entry1.2.1a

I want to set my dimention in a chart as the Level 3 entries under a spercidied level 2 entry eg.

I want my dimention to be Entry1.1.1, Entry1.1.2.

I tried to use =if(Level2='Entry1.1',Level3), but this is not working for some reason.

Any help will be appreciated.

Regards

Karabo

[#2]

You can put a file (qlikview) with a large hierarchy table? thanks

[#3]

Yes, but my table is not too large just 7 levels and about 200 entries in total.