topic Calculating values in pivot in QlikView https://community.qlik.com/t5/QlikView/Calculating-values-in-pivot/m-p/866197#M303022 <HTML><HEAD></HEAD><BODY><P>Hi! </P><P></P><P>I have a table in my script with Registered and Processed dates of tickets.</P><P>If the ticket wasnt processed according to target it's failed.&nbsp; And in my pivot i have the number of failed tickets according to processed dates.</P><P>However, the ticket can be registered in January, for example, with 10 days target. And this ticket can be processed in March.</P><P>So this ticket is failed starting from January&nbsp; till March.</P><P></P><P>Can I create some sort of expression in pivot to count such tickets the way I've explained above?</P><P></P><P>My sample data is attached.</P></BODY></HTML> Mon, 20 Apr 2015 10:56:17 GMT 2015-04-20T10:56:17Z Calculating values in pivot https://community.qlik.com/t5/QlikView/Calculating-values-in-pivot/m-p/866197#M303022 <HTML><HEAD></HEAD><BODY><P>Hi! </P><P></P><P>I have a table in my script with Registered and Processed dates of tickets.</P><P>If the ticket wasnt processed according to target it's failed.&nbsp; And in my pivot i have the number of failed tickets according to processed dates.</P><P>However, the ticket can be registered in January, for example, with 10 days target. And this ticket can be processed in March.</P><P>So this ticket is failed starting from January&nbsp; till March.</P><P></P><P>Can I create some sort of expression in pivot to count such tickets the way I've explained above?</P><P></P><P>My sample data is attached.</P></BODY></HTML> Mon, 20 Apr 2015 10:56:17 GMT https://community.qlik.com/t5/QlikView/Calculating-values-in-pivot/m-p/866197#M303022 2015-04-20T10:56:17Z