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: 
raghavsurya
Partner - Specialist
Partner - Specialist

merge records in straight table

Hi All,

We have a scenario wherein we need to show the qualifications/skill sets acquired by an employee during a period.  The table structure is as mentioned below.

DateNameQualification
30-Apr-11AlanGraduation
10-May-11BillGraduation
12-Jun-11JoshGraduation
10-May-11AlanMasters certification

In a straight table chart we need to show Graduation, Masters Certification against the employee Alan.  How to do this.  ..... Regards,

Raghav

2 Replies
sbaldwin
Partner - Creator III
Partner - Creator III

Hi, if you have a known and constant list you could use an expression like this

=only({<Qualification={'Graduation'}>}   Qualification&',')&

only({<Qualification={'Masters certification'}>}  Qualification)

but this would only work if Qualification wasn't a dimension in your table. if you wanted to show the Qualification i would suggest if you sort your table as you are loading it by the Name then you could add a column which concatenated the Qualifications like this:

if(peek(Name)=Name,peek(Qualification)&',') &Qualification as concatenated_qualification

Thanks

Steve

raghavsurya
Partner - Specialist
Partner - Specialist
Author

Hi Steve, Thanks for your inputs... it almost worked.  I am facing one new issue now, I have show additional qualifications acquired by employees during the latest month.  I am trying with Date function.... but its giving me desired result.  Can you please suggest me how to pick the qualification acquired during the latest quarter/month.  Regards