Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Pivot Table - Layout Problem

Most of my questions were resolved quickly by the search function.

This Time, i could not find an answer.

So here is my Problem: I want to compare Temparatures in identical buildings in the same area.

"Location" is simply a sensor in an "area"

The Data is imported from excel files like this

table_1.jpg

to preven having attributes like Location_1, Location_2 etc. the Data is transformed (by using crosstable) to:

table_2.jpg

I have loaded the current tables for building A and B. (Date, Location, Temperature(A or B))

Now i want to display the data of building A and building B in a pivot table

at the moment, it looks like this:

table_3_pivot_SOLL.jpg

But it should look like this:

table_3_pivot_SOLL.jpg

Im looking forward to your suggestions

1 Solution

Accepted Solutions
Not applicable

Re: Pivot Table - Layout Problem

Hi,

Not sure , i have understood your problem. Have a look at the attached application.

- Sridhar

6 Replies
rahulgupta
Contributor III

Re: Pivot Table - Layout Problem

Hi .

U can shift the column from vertical view to horizontal view.

see the image below.

Re: Pivot Table - Layout Problem

Hi,

You need to click and drag the field Location field and drag it to top right untill a blue horizontal arrow not comes and then just release that field there then you see your location field pivoted according to columns.

Try it hope this helps you.

Regards,

Anand

Not applicable

Pivot Table - Layout Problem

I tried both before, but i cant move them that way i want them to.

Unless i LOAD EVERY Sensor in its own Attribute (Location_1, Location_1B, Location_2), i cant get the view i want.

Pivot Table - Layout Problem

Hi,

Do you have any sample file in this case it will going more easy for you. If you provide i explain to you on that.

Regards,

Anand

Not applicable

Re: Pivot Table - Layout Problem

Thanks alot Anand (and everyone else)

The tables for building A and B are in the tables "Build_A" and "Build_B"

Not applicable

Re: Pivot Table - Layout Problem

Hi,

Not sure , i have understood your problem. Have a look at the attached application.

- Sridhar

Community Browser