topic Re: Pivot table should not collapse in QlikView

Pivot table should not collapse

Anonymous — Tue, 13 May 2014 10:42:00 GMT

Hi All,

As per requirement whenever I click on the 'CATEGORY' it should not collapse and move on to next sheet and Current Selection persist.

please find attachments for reference.

Suggest plz

Thanks

Manish Madan

Re: Pivot table should not collapse

Tue, 13 May 2014 10:47:53 GMT

use the expression like

sum({1},0) check this once

Re: Pivot table should not collapse

SunilChauhan — Tue, 13 May 2014 10:53:17 GMT

still i dont understand your requirement

but i hope

allow fully expanded in presentation tab of chart properties will helps you

hope this helps

Re: Pivot table should not collapse

karolina_ — Tue, 13 May 2014 11:07:43 GMT

I'm not sure either about your requirement. You might need to check "read only" on 'general' tab in chart properties

Re: Pivot table should not collapse

Anonymous — Tue, 13 May 2014 12:44:38 GMT

Thanks Rao,Sunil and Karolina for your help and suggestions.

Elaborating again in more details as you can see my attachment, what i want is when i click on the category values it is collapsing and displaying the current selection which i don't want , what i want is to it change the graph on my selection also and there should not be any impact on pivot table it should all the categories and Catelog's.

i got the solution for this i wrote an expression:

FOR:ALL_ITEMS

sum({<[CATALOG] = ,[CATEGORY]=>}ALL_ITEMS )

INVALID_ITEM:

sum({<[CATALOG] = ,[CATEGORY]=>}INVALID_ITEM)

Thanks again for your help,let me know if i could also help u all in any manner.