Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Unmerge cells in pivot table

Hello,

How can I unmerge dimension cells in pivot table?

Thank you!

4 Replies
New Contributor III

Re: Unmerge cells in pivot table

My pivot table looks like this:

 

AccountLine123
11100100100
2200100200
3300200100
21100100200
2500300100
3200100300

and I need it to be like:

 

AccountLine123
11100100100
12200100200
13300200100
21100100200
22500300100
23200100300

Any ideas?

Highlighted

Re: Unmerge cells in pivot table

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

Highlighted
New Contributor III

Re: Unmerge cells in pivot table

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.

Highlighted
New Contributor III

Re: Unmerge cells in pivot table

Hi,
Did you find out how to do it?