Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Pivot tables

I am struggling to get data in pivot table to appear correct. Some data show up correct, but in the example below, two records with the same timestamp won't, but others will. Any clues as to how this is?

The 'Create Task' and 'Create Taks PutTask' records, time 11:50:00 show up correct, but the Maintenance column shows at it's own line.

JPG1.jpg

6 Replies
Highlighted
Partner
Partner

Re: Pivot tables

I would suggest looking at your data model. How is table containing maintenance column associated with the other fields.
Highlighted
Contributor III
Contributor III

Re: Pivot tables

I've stored the table in my script and done a csv import in excel. - The data for the upper yellow box is shown below. I Only sum data which in Double column are True. Expected result is that 'Create Task PutTask and Maintenance show up on the same line, but in their respective columns:

DateTimeWeekMonthYearPRegionUnitSystemMeasureDoubleSeconds
05-07-201910:55:0027jul2019P1RHRH-HIHTask SystemBook TaskFalse0
05-07-201910:55:0027jul2019P1RHRH-HIHTask SystemCreate Task PutTaskTrue80
05-07-201910:55:0027jul2019P1RHRH-HIHTask SystemCreate TaskFalse0
05-07-201910:55:0027jul2019P1RHRH-HIHTask SystemMaintenanceTrue300

 

Highlighted
Partner
Partner

Re: Pivot tables

that will not happen because of your data there are 2 rows for that calculation 1 with Maintenance and another one with Create Task PutTask (non zero values). 

You need to do cross table load and load your data something like below 

https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

DateTimeWeekMonthYearPRegionUnitSystemBook TaskCreate Task PutTaskCreate TaskMaintenance
5/7/201910:55:0027jul2019P1RHRH-HIHTask System08003000
Highlighted
Contributor III
Contributor III

Re: Pivot tables

Oh - thank you - I'll look into it. May take a while.

Thank you!

Highlighted
Contributor III
Contributor III

Re: Pivot tables

I'm looking at another instance in my data:

DateTimeWeekMonthYearPRegionUnitSystemMeasureDoubleSeconds
05-07-201911:50:0027jul2019P1WestT1ACreate Task PutTaskTrue43
05-07-201911:50:0027jul2019P1WestT1ACreate TaskTrue17
05-07-201911:50:0027jul2019P1WestT1AMaintenanceTrue300


This shows up right in the pivot table (everything expanded), but for the Maintenance record. I agree that it probably is data related, but I have checked the Date and Time and they and have null in their respective time and date parts, and I am clueless.

Highlighted
Digital Support
Digital Support

Re: Pivot tables

Claus, have a look at the following, it may be in play here, but I am not sure, wanted to toss it out there just in case.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

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.