Pivot tables

[clausbarlose]

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.

[dplr-rn]

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

[clausbarlose]

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:

Date	Time	Week	Month	Year	P	Region	Unit	System	Measure	Double	Seconds
05-07-2019	10:55:00	27	jul	2019	P1	RH	RH-HIH	Task System	Book Task	False	0
05-07-2019	10:55:00	27	jul	2019	P1	RH	RH-HIH	Task System	Create Task PutTask	True	80
05-07-2019	10:55:00	27	jul	2019	P1	RH	RH-HIH	Task System	Create Task	False	0
05-07-2019	10:55:00	27	jul	2019	P1	RH	RH-HIH	Task System	Maintenance	True	300

[dplr-rn]

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

Date

Time

Week

Month

Year

P

Region

Unit

System

Book Task

Create Task PutTask

Create Task

Maintenance

5/7/2019

10:55:00

27

jul

2019

P1

RH

RH-HIH

Task System

0

80

0

3000

[clausbarlose]

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

Thank you!

[clausbarlose]

I'm looking at another instance in my data:

Date	Time	Week	Month	Year	P	Region	Unit	System	Measure	Double	Seconds
05-07-2019	11:50:00	27	jul	2019	P1	West	T1	A	Create Task PutTask	True	43
05-07-2019	11:50:00	27	jul	2019	P1	West	T1	A	Create Task	True	17
05-07-2019	11:50:00	27	jul	2019	P1	West	T1	A	Maintenance	True	300

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.

[Brett_Bleess]

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