Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

manish_madan
New Contributor III

Pivot table should not collapse

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

4 Replies
Not applicable

Re: Pivot table should not collapse

use the expression like

sum({1},0)  check this once

chauhans85
Esteemed Contributor

Re: Pivot table should not collapse

still i dont understand your requirement

but i hope

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

hope this helps

karolina_
Contributor II

Re: Pivot table should not collapse

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

manish_madan
New Contributor III

Re: Pivot table should not collapse

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.

Community Browser