Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
simonagheo
Contributor III
Contributor III

Unmerge cells in pivot table

Hello,

How can I unmerge dimension cells in pivot table?

Thank you!

4 Replies
simonagheo
Contributor III
Contributor III
Author

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?

sunny_talwar

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

simonagheo
Contributor III
Contributor III
Author

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.

ceciliafujita
Contributor III
Contributor III

Hi,
Did you find out how to do it?