topic Re: Creating case history out of SAP SolMan exports in QlikView https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027373#M643749 <HTML><HEAD></HEAD><BODY><P>Hi, see attachment as an example of the output I want.</P><P></P><P>Regards</P><P>Trond E ! !</P></BODY></HTML> Tue, 19 Jan 2016 19:08:49 GMT 2016-01-19T19:08:49Z Creating case history out of SAP SolMan exports https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027371#M643747 <HTML><HEAD></HEAD><BODY><P>Hi guys and girls!</P><P></P><P>Se attachement.</P><P></P><P>We are daily dumping all incidents out of SAP SolMan and I am trying to make this into a nice report for my testlead. </P><P></P><P>The lifespan of one specific incident runs from the first entry (pr StatusDato) until it gets the status "Closed" or "Canceled". I want to remove all entires after the first date which one ID gets this status.</P><P></P><P>How can i accomplish that in the most effective way?</P><P></P><P>Best regards</P><P>Trond E</P></BODY></HTML> Tue, 19 Jan 2016 11:58:20 GMT https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027371#M643747 2016-01-19T11:58:20Z Re: Creating case history out of SAP SolMan exports https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027372#M643748 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Can you post the sample output in excel for any StatusDato?</P></BODY></HTML> Tue, 19 Jan 2016 16:45:52 GMT https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027372#M643748 settu_periasamy 2016-01-19T16:45:52Z Re: Creating case history out of SAP SolMan exports https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027373#M643749 <HTML><HEAD></HEAD><BODY><P>Hi, see attachment as an example of the output I want.</P><P></P><P>Regards</P><P>Trond E ! !</P></BODY></HTML> Tue, 19 Jan 2016 19:08:49 GMT https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027373#M643749 2016-01-19T19:08:49Z Re: Creating case history out of SAP SolMan exports https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027374#M643750 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Check the Attachments..</P><P>I created the QVD file based on your qvw file. Then i created the Deleted Flag.</P><P>And, i removed the repeated 'Cancled' and 'Closed' status..</P><P>Let us know, if it is not your requirement..</P></BODY></HTML> Wed, 20 Jan 2016 02:17:32 GMT https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027374#M643750 settu_periasamy 2016-01-20T02:17:32Z Re: Creating case history out of SAP SolMan exports https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027375#M643751 <HTML><HEAD></HEAD><BODY><P>Hi <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> And thank you for your sollution. This community continues to be the best ever <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P></P><P>The sollution was really simpel, I was trying something along those lines myself without success. </P><P></P><P>What I really want to accomplish is that I want to measure the number of open incidents for any given StatusDato with the correct status. (From created date to closed/canceled date). Maybe by using SCD Type 2 vaild_from/valid_to or populating all records for all dates in the appropriate timespan.</P><P></P><P>If you have any clues to point me in the right direction I would be glad.</P><P></P><P>Thanks again.</P><P></P><P>Best regards</P><P>Trond Erik</P></BODY></HTML> Wed, 20 Jan 2016 09:35:11 GMT https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027375#M643751 2016-01-20T09:35:11Z Re: Creating case history out of SAP SolMan exports https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027376#M643752 <HTML><HEAD></HEAD><BODY><P>Welcome. Let me check it.</P></BODY></HTML> Wed, 20 Jan 2016 10:33:51 GMT https://community.qlik.com/t5/QlikView/Creating-case-history-out-of-SAP-SolMan-exports/m-p/1027376#M643752 settu_periasamy 2016-01-20T10:33:51Z