topic Subtract agregation from two dimensions in App Development https://community.qlik.com/t5/App-Development/Subtract-agregation-from-two-dimensions/m-p/1305071#M27752 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm very new to qlik and I'm struggling with the desktop version to analyze our helpdesk ticketing tool. I'm trying to draw the evolution of our backlog (tickets opened - ticket closed by month).</P><P></P><P>I have two dimensions: creation date (per month) and closed date (per month). I'm playing with to tables.</P><P></P><P>The first one has:</P><P>- Dimension= opened date</P><P>- Measure= rangesum(above(count(ID),0,rowno())) </P><P></P><P>The second one has:</P><P>- Dimension =closed date</P><P>- Measure=rangesum(above(count(ID),0,rowno())) </P><P></P><P>But I don't know how to put it together in order to have cumulative opened - cumulative closed, I don't know how to play it in the same table/chart in order to subtract the two values.</P><P></P><P>Could you please help me on it?</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 12 Apr 2017 08:38:29 GMT 2017-04-12T08:38:29Z Subtract agregation from two dimensions https://community.qlik.com/t5/App-Development/Subtract-agregation-from-two-dimensions/m-p/1305071#M27752 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm very new to qlik and I'm struggling with the desktop version to analyze our helpdesk ticketing tool. I'm trying to draw the evolution of our backlog (tickets opened - ticket closed by month).</P><P></P><P>I have two dimensions: creation date (per month) and closed date (per month). I'm playing with to tables.</P><P></P><P>The first one has:</P><P>- Dimension= opened date</P><P>- Measure= rangesum(above(count(ID),0,rowno())) </P><P></P><P>The second one has:</P><P>- Dimension =closed date</P><P>- Measure=rangesum(above(count(ID),0,rowno())) </P><P></P><P>But I don't know how to put it together in order to have cumulative opened - cumulative closed, I don't know how to play it in the same table/chart in order to subtract the two values.</P><P></P><P>Could you please help me on it?</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 12 Apr 2017 08:38:29 GMT https://community.qlik.com/t5/App-Development/Subtract-agregation-from-two-dimensions/m-p/1305071#M27752 2017-04-12T08:38:29Z