topic Re: Hierarchy hides values in pivot table when selected in QlikView

Hierarchy hides values in pivot table when selected

Fri, 21 Sep 2012 12:53:30 GMT

Hi -

I created a hierarchy which is loaded as part of my script.

When this hierachy is used as part of my selections, all values get filtered out. Any idea on why my hierachy hides all values in my pivot table?

Thank you!!!!!

CrossTable(Period, Data, 5)

LOAD [Row Labels] as [Test Description],

[Profit_Center],

[Currency],

[GL Account],

[Gl Account Description],

[Period 12 FY2009],

[Period 1 FY2010],

[Period 2 FY2010],

[Period 3 FY2010],

[Period 4 FY2010],

[Period 5 FY2010],

[Period 6 FY2010],

[Period 7 FY2010],

[Period 8 FY2010],

[Period 9 FY2010],

[Period 10 FY2010],

[Period 11 FY2010]

FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1, filters(

Replace(1, bottom, StrCnd(null)),

Replace(2, bottom, StrCnd(null)),

Replace(3, bottom, StrCnd(null)),

Replace(4, bottom, StrCnd(null)),

Replace(5, bottom, StrCnd(null))

));

Profit_Center:

LOAD * Inline [

All, Region, Profit_Center, Website_Country

All, Test1, A

All, Test1, B, C

All, Test1, B,C, D

];

Hierarchy_Table:

Load * ,

All &'-'&Region&'-'&Profit_Center&'-'&Website_Country as HierarchyPath

Resident Profit_Center;

Drop table Profit_Center;

Re: Hierarchy hides values in pivot table when selected

whiteline — Sat, 22 Sep 2012 08:20:03 GMT

Hi.

Your Hierarchy table connected with your data through Profit_Center field.

Create a Listbox with Profit_Center and check that the values 'A','B' exist in your Data table (the one you loaded first).

Re: Hierarchy hides values in pivot table when selected

Mon, 24 Sep 2012 12:49:39 GMT

Hi - yes i checked and they do.

Re: Hierarchy hides values in pivot table when selected

whiteline — Mon, 24 Sep 2012 13:49:56 GMT

So, it should work.

They should exist in both tables.

Test only first load statmenet (temporarily comment the rest).

Re: Hierarchy hides values in pivot table when selected

Mon, 24 Sep 2012 16:29:27 GMT

No it doesn't work. Any ideas?

Thank you

Re: Hierarchy hides values in pivot table when selected

Mon, 24 Sep 2012 17:00:33 GMT

Actually you are right the A, B values do not exist. How can i make a connectiong between the two?

Thank you

Re: Hierarchy hides values in pivot table when selected

whiteline — Tue, 25 Sep 2012 06:36:14 GMT

Hi.

You have the connection. You don't have values.

I guess only you can answer the question why you use different values in you inline table for Profit_Center.