Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Transpose rows into columns

Hi all.

I have this table.

ProjectWorkPrice 2014
Project_1Documentation1000
Project_1Constraction2000
Project_1End3000
Project_2Documentation1500
Project_2Constraction2500
Project_2End3000

How I can create this table?

ProjectDocumentationConstractionEnd
Project_1100020003000
Project_2150025003000

I must use crosstable?

Thank you.

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Transpose rows into columns

No, the opposite: a generic load.

Generic

LOAD * INLINE [

    Project, Work, Price 2014

    Project_1, Documentation, 1000

    Project_1, Constraction, 2000

    Project_1, End, 3000

    Project_2, Documentation, 1500

    Project_2, Constraction, 2500

    Project_2, End, 3000

];

See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Transpose rows into columns

No, the opposite: a generic load.

Generic

LOAD * INLINE [

    Project, Work, Price 2014

    Project_1, Documentation, 1000

    Project_1, Constraction, 2000

    Project_1, End, 3000

    Project_2, Documentation, 1500

    Project_2, Constraction, 2500

    Project_2, End, 3000

];

See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

Re: Transpose rows into columns

Thank you!