topic Pivot Table - Layout Problem in QlikView

Pivot Table - Layout Problem

Thu, 11 Aug 2011 10:38:33 GMT

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

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

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:

But it should look like this:

Im looking forward to your suggestions

Re: Pivot Table - Layout Problem

rahulgupta — Thu, 11 Aug 2011 10:55:52 GMT

Hi .

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

see the image below.

Re: Pivot Table - Layout Problem

its_anandrjs — Thu, 11 Aug 2011 11:08:21 GMT

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

Pivot Table - Layout Problem

Thu, 11 Aug 2011 13:29:51 GMT

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

its_anandrjs — Thu, 11 Aug 2011 14:07:43 GMT

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

Re: Pivot Table - Layout Problem

Thu, 11 Aug 2011 15:04:38 GMT

Thanks alot Anand (and everyone else)

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

Re: Pivot Table - Layout Problem

Thu, 11 Aug 2011 15:06:59 GMT

Hi,

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

- Sridhar