topic Re: How to create a pivot table like this... in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-like-this/m-p/755460#M1043307 <HTML><HEAD></HEAD><BODY><P>Sorry, I'm painfully new to this, could you specify a bit more?</P><P></P><P>Is this correct - My dimensions are: Machine, Operator, Program, Start.</P></BODY></HTML> Tue, 02 Dec 2014 23:54:31 GMT 2014-12-02T23:54:31Z How to create a pivot table like this... https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-like-this/m-p/755458#M1043305 <HTML><HEAD></HEAD><BODY><P>What kind of expressions do I use to create a pivot table like this?</P><P></P><P>Any help would be much appreciated!</P></BODY></HTML> Tue, 02 Dec 2014 00:13:19 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-like-this/m-p/755458#M1043305 2014-12-02T00:13:19Z Re: How to create a pivot table like this... https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-like-this/m-p/755459#M1043306 <HTML><HEAD></HEAD><BODY><P>alt(only([Machine Start]) - above(only([Machine Stop])),0)</P></BODY></HTML> Tue, 02 Dec 2014 01:14:09 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-like-this/m-p/755459#M1043306 simenkg 2014-12-02T01:14:09Z Re: How to create a pivot table like this... https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-like-this/m-p/755460#M1043307 <HTML><HEAD></HEAD><BODY><P>Sorry, I'm painfully new to this, could you specify a bit more?</P><P></P><P>Is this correct - My dimensions are: Machine, Operator, Program, Start.</P></BODY></HTML> Tue, 02 Dec 2014 23:54:31 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-like-this/m-p/755460#M1043307 2014-12-02T23:54:31Z Re: How to create a pivot table like this... https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-like-this/m-p/755461#M1043308 <HTML><HEAD></HEAD><BODY><P>The above functions should return the value for the line above it. So Machine Start - Above (Machine Stop) should give you the time between production. </P><P></P><P>If that is not your desired result then you need to specify your expectations. </P></BODY></HTML> Wed, 03 Dec 2014 08:18:20 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-like-this/m-p/755461#M1043308 simenkg 2014-12-03T08:18:20Z