topic Re: Unmerge cells in pivot table in QlikView

Unmerge cells in pivot table

simonagheo — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

How can I unmerge dimension cells in pivot table?

Thank you!

Re: Unmerge cells in pivot table

simonagheo — Tue, 31 May 2016 09:52:11 GMT

My pivot table looks like this:

Account	Line	1	2	3
1	1	100	100	100
	2	200	100	200
	3	300	200	100
2	1	100	100	200
	2	500	300	100
	3	200	100	300

and I need it to be like:

Account	Line	1	2	3
1	1	100	100	100
1	2	200	100	200
1	3	300	200	100
2	1	100	100	200
2	2	500	300	100
2	3	200	100	300

Any ideas?

Re: Unmerge cells in pivot table

sunny_talwar — Tue, 31 May 2016 18:14:24 GMT

Use straight table with three expressions rather than using the pivot table because I don't think pivot table will allow you to do what you are trying to achieve here

Re: Unmerge cells in pivot table

simonagheo — Fri, 03 Jun 2016 11:15:28 GMT

The problem is that I need a horizontal dimension called period (with values: 1,2,3.....) like in the above example, and I don't know how to do this in straight table.

Re: Unmerge cells in pivot table

ceciliafujita — Tue, 14 May 2019 22:00:44 GMT

Hi,
Did you find out how to do it?

Re: Unmerge cells in pivot table

manish_gupta — Wed, 30 Apr 2025 03:12:49 GMT

Hello All,

did anyone find the solution for this in Qliksense ?

Thank you