Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
gf
Creator III
Creator III

Hide expand icon in pivot table

Hello all,

Is it possible to hide the expand icon in a pivot table. I don't want to fully expand my table.

clipboard_image_0.png

Labels (5)
1 Solution

Accepted Solutions
rwunderlich

Forget my suggestion about two charts. Instead, you can conditionally show hide/columns as shown here. 

Qlikview Cookbook: Tutorial - About Column Visibility http://qlikviewcookbook.com/recipes/download-info/tutorial-about-column-visibility/

The sheet "Conditional (Dynamic) Columns" matches your question exactly.

2019-10-08_07-58-49 (1).gif

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

View solution in original post

8 Replies
ajaykakkar93
Specialist
Specialist

Hi,

Do you want to apply to all the pivot table??

If yes then what is your qlik sense version?

Can you use custom theme?

Regsrds,

Ajay Kakkar

 

gf
Creator III
Creator III
Author

Thanks for your answer  @ajaykakkar93 .

Yes. I have two pivot tables where i want to "hide" the expand(+)/collapse(-) icon.

I work with QlikView, not QlikSense.

 

Regards,

gf 

ajaykakkar93
Specialist
Specialist

I dont have expertise in Qlik View Sorry. 

rwunderlich

How about setting "always fully expanded" and don't define the intermediate dimensions that you want collapsed? In your picture, define 3 dimensions and 1 expression. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

gf
Creator III
Creator III
Author

No problem! 🙂 But thanks for your time and interest.

gf
Creator III
Creator III
Author

Thanks for your input Rob! 

I need all the dimensions because the pivot can be expand via a button. 

Normal view:

clipboard_image_0.png

After clicking the a button called "Expand":

clipboard_image_1.png

The problem is, the user should not be able to expand anything in the normal view, because then

my expand-macro doesn't work anymore. I thought that if i set the option "Read Only" the user couldn't expand/collapse the pivot but it is still possible. So i need to "hide" the icons in my normal view.

 

Regards! 

rwunderlich

Forget my suggestion about two charts. Instead, you can conditionally show hide/columns as shown here. 

Qlikview Cookbook: Tutorial - About Column Visibility http://qlikviewcookbook.com/recipes/download-info/tutorial-about-column-visibility/

The sheet "Conditional (Dynamic) Columns" matches your question exactly.

2019-10-08_07-58-49 (1).gif

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

gf
Creator III
Creator III
Author

Thank you very much Rob!

I'll give you my response tomorrow 🙂 Hope this is the right solution.