How to detach a Pivot Table in Qlikview.

[#1]

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

[IAMDV]

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]

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.

[#4]

Hi, Thanks for the reply..

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

[IAMDV]

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

[#6]

DV,

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

Regards,
Jeff

[#7]

Thanks .. This has solved by issue

[bluishjoe]

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

[#9]

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!