merge records in straight table

[raghavsurya]

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.

Date	Name	Qualification
30-Apr-11	Alan	Graduation
10-May-11	Bill	Graduation
12-Jun-11	Josh	Graduation
10-May-11	Alan	Masters certification

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

Raghav

[sbaldwin]

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]

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