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: 
Not applicable

How to make column data as headers in qlikview

I am connecting to qlikview via smartsheet, and i wanted column data to be headers, as per attached spreadsheet, i want to use the TG data as column headers

For Eg:

Project Name     TG1     TG2      TG3

A                         20          30     40

B                         100       20     30

So basically in the above way, i want to display the data, how can achieve this in qlikview

2 Replies
MarcoWedel

Hi,

maybe one solution might be:

QlikCommunity_Thread_264818_Pic1.JPG

table1:

Generic

LOAD [Primary Column],

    Column2,

    Column3

Resident [PD__7466735583422340s_(Home)];

hope this helps

regards

Marco

vishsaggi
Champion III
Champion III

Cant you use pivot table and just drag the TG column to the top like below:

Capture.PNG

IF not probably use Marco's Generic Load.