topic Re: Convert values of a column as column headers in QlikView

Convert values of a column as column headers

sureshbaabu — Fri, 17 Jan 2014 06:15:28 GMT

Hello,

I have requirement to convert the values of a particular column as column headers.

In my sample date - I want to convert the values of 'PROFICIENCY' column as individual column headers.

Please find attached sample source date and the required output.

Objective of the requirement - find out an employees secondary/Tertiary skills based on primary skill.

Thank you!!!

Re: Convert values of a column as column headers

sujeetsingh — Fri, 17 Jan 2014 06:44:32 GMT

Go for Generic Load.

Follow these links

Qlikview Notes: Use cases for Generic Load

Re: Convert values of a column as column headers

kiranmanoharrode — Fri, 17 Jan 2014 06:45:32 GMT

dear Surest,

Just copy paste your expression to Label input box for selection in your Dimension.

If you want to show total of all values in column

then add Total keyword into your expression

=Sum(Total Measure)

Regards
Kiran Rode

+91 8976977897

Re: Convert values of a column as column headers

Gysbert_Wassenaar — Fri, 17 Jan 2014 06:58:43 GMT

Simply use a pivot table to display the data. See attached qvw

Re: Convert values of a column as column headers

sureshbaabu — Fri, 17 Jan 2014 06:59:10 GMT

Hello,

the requirement is not for showing up the total. Could you please check the attachments?

I have the both source and the output files, thanks

Re: Convert values of a column as column headers

sureshbaabu — Fri, 17 Jan 2014 07:22:14 GMT

Hello,

Thanks for the response.

I too tried that, but we cant look at an employees secondary/Tertiary skills when you make a selection on any primary skills.

on you example. Please create a list box for Skill group and make a selection.

I believe having 3 filters one for Primary with Primary skills, secondary with secondary skills and Tertiary with Tertiary skills would help us achieve this.

Thanks

Re: Re: Convert values of a column as column headers

Gysbert_Wassenaar — Fri, 17 Jan 2014 07:28:56 GMT

See attached qvw

Re: Convert values of a column as column headers

sureshbaabu — Fri, 17 Jan 2014 09:15:14 GMT

Cool, That's right. Splitting the data and merging it would be the right thing to do. Thank you!!!