Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
m_perreault
Creator III
Creator III

Cross Table Help

Hi All I have the below table.  The columns '5555','6666','7777' are ParentID's and their values are ownership percentages of the ChildID in column 1

ChildIDDescriptionMonthEnd555566667777
5005ABC CompanyJan18.333.333.333
5005ABC CompanyFeb18.5.25.25
5005ABC CompanyMarch18.5.50

I'd like to use the cross table function to create the below table does anyone have any ideas?

ChildIDDescriptionMonthEndParentIDOwnership %
5005ABC CompanyJan185555.333
5005ABC CompanyJan186666.333
5005ABC CompanyJan187777

.333

5005ABC CompanyFeb185555.5
5005ABC CompanyFeb186666.25
5005ABC CompanyFeb187777.25
5005ABC CompanyMarch185555.5
5005ABC CompanyMarch186666.5
5005ABC CompanyMarch1877770
1 Solution

Accepted Solutions
m_perreault
Creator III
Creator III
Author

It was simpler than I realized

CrossTable([Parent ID],Ownership,3)

Load *

From MyTable

View solution in original post

1 Reply
m_perreault
Creator III
Creator III
Author

It was simpler than I realized

CrossTable([Parent ID],Ownership,3)

Load *

From MyTable

View solution in original post