Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register 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!

5 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?
manish_gupta
Contributor III
Contributor III

Hello All,

 

did anyone find the solution for this in Qliksense ?

 

Thank you