Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Author

use the expression like

sum({1},0)  check this once

SunilChauhan
Champion
Champion

still i dont understand your requirement

but i hope

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

hope this helps

Sunil Chauhan
karolina_
Creator II
Creator II

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

Anonymous
Not applicable
Author

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.