topic Re: Pivot table doesn't keep structure in QlikView

Pivot table doesn't keep structure

vchuprina — Mon, 23 Oct 2017 15:26:25 GMT

Hello,

I've a problem with Ad hoc pivot table, it doesn't keep structure. I have around 300 dimension and only four measures.

When I choose a dimension I have unstructured table: dimension and measures stay in one row

Incorrect

Then I manually transform incorrect table to correct version. But after reopen Qlik shows first version of table.

What is possible reason of issue?

Correct

Re: Pivot table doesn't keep structure

Anonymous — Mon, 23 Oct 2017 15:52:53 GMT

could you give us the QVW to see and work with?

Re: Pivot table doesn't keep structure

devarasu07 — Mon, 23 Oct 2017 16:00:56 GMT

Hi,

Hope that you manually transformed the column into row via web browser? if so try to make the same changes via qlikview desktop then save it after that re-load app into you server. then transformed view will shows always. thanks

Regards,

Deva