topic Re: Hide expand icon in pivot table in QlikView

Hide expand icon in pivot table

gf — Sat, 16 Nov 2024 02:16:54 GMT

Hello all,

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

Re: Hide expand icon in pivot table

ajaykakkar93 — Tue, 08 Oct 2019 14:10:04 GMT

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

Re: Hide expand icon in pivot table

gf — Tue, 08 Oct 2019 14:27:50 GMT

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,

Re: Hide expand icon in pivot table

ajaykakkar93 — Tue, 08 Oct 2019 14:29:52 GMT

I dont have expertise in Qlik View Sorry.

Re: Hide expand icon in pivot table

rwunderlich — Tue, 08 Oct 2019 14:31:26 GMT

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

Re: Hide expand icon in pivot table

gf — Tue, 08 Oct 2019 14:31:46 GMT

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

Re: Hide expand icon in pivot table

gf — Tue, 08 Oct 2019 14:38:28 GMT

Thanks for your input Rob!

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

Normal view:

After clicking the a button called "Expand":

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!

Re: Hide expand icon in pivot table

rwunderlich — Tue, 08 Oct 2019 15:02:28 GMT

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.

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

Re: Hide expand icon in pivot table

gf — Tue, 08 Oct 2019 15:09:18 GMT

Thank you very much Rob!

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