topic business process like charting in QlikView https://community.qlik.com/t5/QlikView/business-process-like-charting/m-p/227644#M79748 <HTML><HEAD></HEAD><BODY><DIV>Hello QVers,<BR />at the moment I'm going round in circles finding a solution.<BR />For better visualisation for what I want see attached qvw file [QV9].</DIV><DIV>There are CASEs belonging to one - sometimes identical - DRG, these have several PERFormances with a - sometimes identical - individual Date (DATEPERF) inbetween each CASE / DRG.</DIV><DIV>Like a business process I want to see the distribution of PERFs for identical DRGs originating from one or more CASEs.<BR />I want to know how often one PERF is first, second aso in sequence inbetween a DRG.</DIV><DIV>My considerations are:<BR />First step: the individual DATEPERF should be grouped from min to max inbetween each DRG per CASE;<BR />- How to do that when the source is not grouped?<BR />Second step: the lowest DATEPERF should get order number #1, second lowest #2 and so on till highest to obtain a consecutive ordering [as RESULT=field created manually] independent from individual DATEPERF;<BR />- How to do?</DIV><DIV>Presuming QVers are sharing my considerations to do this or another way so let me know your ideas and I would appreciate your proposals.<BR />Thank You in advance.</DIV><DIV>Greetings dj_skbs</DIV></BODY></HTML> Thu, 29 Apr 2010 11:32:06 GMT 2010-04-29T11:32:06Z business process like charting https://community.qlik.com/t5/QlikView/business-process-like-charting/m-p/227644#M79748 <HTML><HEAD></HEAD><BODY><DIV>Hello QVers,<BR />at the moment I'm going round in circles finding a solution.<BR />For better visualisation for what I want see attached qvw file [QV9].</DIV><DIV>There are CASEs belonging to one - sometimes identical - DRG, these have several PERFormances with a - sometimes identical - individual Date (DATEPERF) inbetween each CASE / DRG.</DIV><DIV>Like a business process I want to see the distribution of PERFs for identical DRGs originating from one or more CASEs.<BR />I want to know how often one PERF is first, second aso in sequence inbetween a DRG.</DIV><DIV>My considerations are:<BR />First step: the individual DATEPERF should be grouped from min to max inbetween each DRG per CASE;<BR />- How to do that when the source is not grouped?<BR />Second step: the lowest DATEPERF should get order number #1, second lowest #2 and so on till highest to obtain a consecutive ordering [as RESULT=field created manually] independent from individual DATEPERF;<BR />- How to do?</DIV><DIV>Presuming QVers are sharing my considerations to do this or another way so let me know your ideas and I would appreciate your proposals.<BR />Thank You in advance.</DIV><DIV>Greetings dj_skbs</DIV></BODY></HTML> Thu, 29 Apr 2010 11:32:06 GMT https://community.qlik.com/t5/QlikView/business-process-like-charting/m-p/227644#M79748 2010-04-29T11:32:06Z