Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

In Qlik Sense, how do I combined two different rows?

I have a table with student data. the students each have row for each exam they took. I need to merge the rows somehow so that each student has one row with each exam grade taking up one column. There are only two exams. Is there an easy way to do this?

For example in the example below I need these two records into one row and really just the exam grade into one or the other row. 

 

 

Untitled.png

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Try a Pivot table like this:

Capture.PNG

View solution in original post

3 Replies
Highlighted
Creator III
Creator III

Is this what you want? Just create a Pivot table and follow the settings in picture below.

Aww I don't know why I could not add an image here. Please view it in the attachment

 
 
Highlighted
Creator III
Creator III

Try a Pivot table like this:

Capture.PNG

View solution in original post

Highlighted
Partner
Partner

Yes! thank you very much, that really helped. I do have one more question though. 

If both exams are passed is there a way to hide those records? Seems like I would have to create some logic on those specific columns in the pivot table but I am not sure how to do that.