Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

haymarketpaul
Contributor III

Transpose? Crosstable? Generic Load?

QV11 SR2

I'm trying to work out the best way to transpose the following data.  I've been looking at possibly using transpose, crosstable or generic load but i'm not quite which if any are the best to use.  Any advice much appreciated.

Data.gif

This is the format i am trying to achieve...

Result.gif

1 Solution

Accepted Solutions
anandathome
Contributor

Re: Transpose? Crosstable? Generic Load?

Please find attached.

You have to drag the Interest Area

field and take it to the right and to the top of column name, it shows a blue line.

Drop it at the top of column name.

5 Replies
Not applicable

Re: Transpose? Crosstable? Generic Load?

If I've understood it correctly, you could create a pivot table and then just drag the Interest Area Dimension to the top of the table, and It will appear just the way you want.

Hope this helps.

Sin título.png

anandathome
Contributor

Re: Transpose? Crosstable? Generic Load?

Can you load this full data into qlikview and then convert it using pivot chart in the way you want?

haymarketpaul
Contributor III

Re: Transpose? Crosstable? Generic Load?

Yes that sounds like it would do the trick  - i can't seem to work out how to drag the column (Job Role) though?  I've attached my qvw if someone could take a quick look that would be great. 

anandathome
Contributor

Re: Transpose? Crosstable? Generic Load?

Please find attached.

You have to drag the Interest Area

field and take it to the right and to the top of column name, it shows a blue line.

Drop it at the top of column name.

haymarketpaul
Contributor III

Re: Transpose? Crosstable? Generic Load?

Ah Got it - Thank you Anand

Community Browser