topic How to save historic data? in QlikView https://community.qlik.com/t5/QlikView/How-to-save-historic-data/m-p/466388#M174301 <HTML><HEAD></HEAD><BODY><P>Hi QlikView-community,</P><P></P><P>I´m importing daily data from Salesforce regarding tickets (questions from customers) that have been open and closed every day.In the raw data from Salesforce there exists two timestamps, one for&nbsp; each new ticket (timestamp_created) and one for each closed ticket&nbsp; (timestamp_closed).</P><P></P><P>QUESTION: I would like to compare the number of open tickets that I had yesterday with the number of open tickets I had the day before. I calculate the number of open tickets adding all tickets that have been created since today minus those that have been closed. Is there a way to calculate the number of open tickets that we have at the end of each day?</P><P></P><P>I am attaching the qlikview app I am using.</P><P></P><P>Thanks in advance!</P><P>David</P></BODY></HTML> Thu, 18 Apr 2013 07:20:04 GMT 2013-04-18T07:20:04Z How to save historic data? https://community.qlik.com/t5/QlikView/How-to-save-historic-data/m-p/466388#M174301 <HTML><HEAD></HEAD><BODY><P>Hi QlikView-community,</P><P></P><P>I´m importing daily data from Salesforce regarding tickets (questions from customers) that have been open and closed every day.In the raw data from Salesforce there exists two timestamps, one for&nbsp; each new ticket (timestamp_created) and one for each closed ticket&nbsp; (timestamp_closed).</P><P></P><P>QUESTION: I would like to compare the number of open tickets that I had yesterday with the number of open tickets I had the day before. I calculate the number of open tickets adding all tickets that have been created since today minus those that have been closed. Is there a way to calculate the number of open tickets that we have at the end of each day?</P><P></P><P>I am attaching the qlikview app I am using.</P><P></P><P>Thanks in advance!</P><P>David</P></BODY></HTML> Thu, 18 Apr 2013 07:20:04 GMT https://community.qlik.com/t5/QlikView/How-to-save-historic-data/m-p/466388#M174301 2013-04-18T07:20:04Z Re: How to save historic data? https://community.qlik.com/t5/QlikView/How-to-save-historic-data/m-p/466389#M174302 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>You can create an auxiliary table with different dates 'CreatedDate' format 'DD / MM / YYYY' and use as dimension. Then you format the 'ClosedDate' and 'CreatedDate' also as 'DD / MM / YYYY' and write the expression.</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>Rebeca</P></BODY></HTML> Thu, 18 Apr 2013 14:04:21 GMT https://community.qlik.com/t5/QlikView/How-to-save-historic-data/m-p/466389#M174302 2013-04-18T14:04:21Z Re: How to save historic data? https://community.qlik.com/t5/QlikView/How-to-save-historic-data/m-p/466390#M174303 <HTML><HEAD></HEAD><BODY><P>The simplest way to get open ticket count is to write an expression in your script using following logic:</P><P></P><P>Use Closeddate column and do a count on cases with Closeddate is null.</P><P></P><P>Or</P><P></P><P>Use status column and do a count on csease with Status = 'Open'</P></BODY></HTML> Thu, 18 Apr 2013 15:01:29 GMT https://community.qlik.com/t5/QlikView/How-to-save-historic-data/m-p/466390#M174303 shilpan 2013-04-18T15:01:29Z Re: How to save historic data? https://community.qlik.com/t5/QlikView/How-to-save-historic-data/m-p/466391#M174304 <HTML><HEAD></HEAD><BODY><P>Hi, thanks for answering.</P><P></P><P>the issue is not how to calculate the number of open tickets but to save those numbers for each day. Otherwise when I reload the query I overwrite the counts with the current status.</P><P></P><P>In other words: I would like to compare the number of open tickets we had yesterday with the number of open tickets we have today.</P><P></P><P>thanks,</P><P>david</P></BODY></HTML> Thu, 25 Apr 2013 12:52:08 GMT https://community.qlik.com/t5/QlikView/How-to-save-historic-data/m-p/466391#M174304 2013-04-25T12:52:08Z Re: How to save historic data? https://community.qlik.com/t5/QlikView/How-to-save-historic-data/m-p/466392#M174305 <HTML><HEAD></HEAD><BODY><P>Hi Rebeca, thanks for answering.</P><P></P><P>the issue is not how to calculate the number of open tickets but to save those numbers for each day. Otherwise when I reload the query I overwrite the counts with the current status.</P><P></P><P>In other words: I would like to compare the number of open tickets we had yesterday with the number of open tickets we have today.</P><P></P><P>thanks,</P><P>david</P></BODY></HTML> Thu, 25 Apr 2013 12:52:36 GMT https://community.qlik.com/t5/QlikView/How-to-save-historic-data/m-p/466392#M174305 2013-04-25T12:52:36Z