Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
timbatman
Contributor
Contributor

How to Cross Table my data

I currently have a table that contains the following columns:

WellID

Date

Production (MCF)

 

I want to create a table as a visual that has dates as columns with 1 row for each well.  What is the best way to achieve this?

Labels (2)
1 Solution

Accepted Solutions
Stoyan_Terziev
Partner
Partner

Hi Tim,

 

I'd recommend you use the Chart -> Pivot Table.

Then Chart Properties -> Presentation -> make sure you have: Allow Pivoting checked. And Always Fully expanded checked.

On the front-end drag and drop the Date dimension so that it appears vertically.

Here is one possible result:

image.png

 

I hope that helps!

 

Here you can have the script loading the data I played with:

Wells:
Load * INLINE [
WellID, Date,Production(MCF)
1,10/23/2019,196
1,10/24/2019,126
1,10/25/2019,116
1,10/26/2019,178
1,10/27/2019,146
1,10/28/2019,128
2,10/23/2019,139
2,10/24/2019,137
2,10/25/2019,184
2,10/26/2019,116
2,10/27/2019,148
2,10/28/2019,178
3,10/23/2019,130
3,10/24/2019,144
3,10/25/2019,105
3,10/26/2019,168
3,10/27/2019,111
3,10/28/2019,167
];

 

Kind regards,

S.T.

View solution in original post

2 Replies
Stoyan_Terziev
Partner
Partner

Hi Tim,

 

I'd recommend you use the Chart -> Pivot Table.

Then Chart Properties -> Presentation -> make sure you have: Allow Pivoting checked. And Always Fully expanded checked.

On the front-end drag and drop the Date dimension so that it appears vertically.

Here is one possible result:

image.png

 

I hope that helps!

 

Here you can have the script loading the data I played with:

Wells:
Load * INLINE [
WellID, Date,Production(MCF)
1,10/23/2019,196
1,10/24/2019,126
1,10/25/2019,116
1,10/26/2019,178
1,10/27/2019,146
1,10/28/2019,128
2,10/23/2019,139
2,10/24/2019,137
2,10/25/2019,184
2,10/26/2019,116
2,10/27/2019,148
2,10/28/2019,178
3,10/23/2019,130
3,10/24/2019,144
3,10/25/2019,105
3,10/26/2019,168
3,10/27/2019,111
3,10/28/2019,167
];

 

Kind regards,

S.T.

View solution in original post

Brett_Bleess
Support (Former)
Support (Former)

Tim, did Stoyan's recommendation work for you?  If so, do not forget to return to the thread and use the Accept as Solution button on his post to give him credit for the help and to let others know things worked for you.  If you are still working on things, leave an update.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.