Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to detach a Pivot Table in Qlikview.

Hi All,

I am having an pivot table in the qvw. I have made it detached using the properties and it will work fine, till the next time it do a reload.

Please can anyone advise me, how to set this property always on.

Thanks,

Sijo

8 Replies
IAMDV
Luminary Alumni
Luminary Alumni

Hi,

Right click on the Pivot Table and then click on Detach. You can do the same for any chart type. Also, include the 1 in Set Analysis to ignore selection. This means you are always looking at full data. $ implies current selectio...

I hope this helps!

Cheers - DV

raghavsurya
Partner - Specialist
Partner - Specialist

Hi,  If you are using set analysis, put 1 before "<" in the expression.  This will ensure that it displays all the values irrespective of any selection made.

Not applicable
Author

Hi, Thanks for the reply..

Is there any other option to do this without putting the set analysis..

IAMDV
Luminary Alumni
Luminary Alumni

Hi,

As explained above... you can {1} for all the data and {$} for current selection. I am attaching a tutorial for your reference.

Good luck!

Cheers - DV

Not applicable
Author

DV,

Very good job on the Set Analysis Presentation.  It was very helpful!

Regards,
Jeff

Not applicable
Author

Thanks .. This has solved by issue

bluishjoe
Contributor III
Contributor III

So accept the answer as "correct answer". In this way everyone will see it's already solved.

Not applicable
Author

Hi everyone,


I know that this is a relatively older thread, and apologies for reopening it, but I have a similar problem to this one with a pivot table I've created...

It used to be a straight table, but there were a lot of dimensions (24), and it was making the screen too large.

I needed it to have a horizontal scroll bar, but of course, you can't really have a horizontal scroll bar on a straight table, but i found a way of doing it by turning it into a pivot table, and leaving 10 dimensions, and then turning the rest into expressions.

A scroll bar now appears, but it does not preserve its position (even when the check box in the 'Layout' tab is ticked - the table also has a vertical scroll bar, which works fine with that option ticked).

This is my problem.  I need my horizontal scroll bar to preserve it's position too.

The only way I have managed it is to detach the pivot table.  However, when the document is reloaded, or just reopened, the table is attached again, and the scroll bar resets.


Can anyone help me with this?


Thanks!