Discussion board where members can get started with QlikView.
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
Go to Solution.
Not sure , i have understood your problem. Have a look at the attached application.
U can shift the column from vertical view to horizontal view.
see the image below.
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.
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.
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.
Thanks alot Anand (and everyone else)
The tables for building A and B are in the tables "Build_A" and "Build_B"