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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-12-01 09:08 AM

Transform 2 groupings from column format to matrice

Hi, I have in column format list with two groupings (something like the source table on the first picture).

0683p000009M1FU.jpgSource table

And I need to transform this table somehow into Matrice format, like the one in second picture. Can someone help me please? Thank you

0683p000009M1FZ.jpg

 

Labels (2)
Labels
131 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2018-12-02 08:41 AM
Author

Hi Lukas, 

 

Have you tried the tPivotToColumnnsDelimited component? It can split the fruit column into individual columns whilst summing the quantity per person. Please see the config below:

 

0683p000009M1Ff.png

 

 

131 Views
0 Likes