topic Check for Previous Instances in QlikView https://community.qlik.com/t5/QlikView/Check-for-Previous-Instances/m-p/1419706#M428491 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been asked to see if it is possible to track if users are using a new system booking system more than they used an old system.&nbsp; Each day we receive data from two systems 'SystemA' and 'SystemB' linked on 'User' and when the application loads I would like to be able to say that from '<EM>today</EM>' onwards, Users are taking more bookings from System B than they were taking from System A ?&nbsp; I have a attached a sample document.</P><P></P><P>So , for example, in the attached document if we take <EM><STRONG>today's</STRONG> </EM>date as 28/01/2017, we can see that User C has taken 5 bookings from System A but going forward User C has taken 7 bookings from System B.</P><P><IMG __jive_id="179050" alt="past_future_ratio.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179050_past_future_ratio.PNG" style="height: auto;" /></P><P></P><P>Is there any suitable way to show this graphically as a number Users' per day going forward compared to the past (as a % or ratio)?</P><P></P><P>Thanks for any help or suggestions!</P><P>Phil</P></BODY></HTML> Mon, 09 Oct 2017 19:31:15 GMT prees959 2017-10-09T19:31:15Z Check for Previous Instances https://community.qlik.com/t5/QlikView/Check-for-Previous-Instances/m-p/1419706#M428491 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been asked to see if it is possible to track if users are using a new system booking system more than they used an old system.&nbsp; Each day we receive data from two systems 'SystemA' and 'SystemB' linked on 'User' and when the application loads I would like to be able to say that from '<EM>today</EM>' onwards, Users are taking more bookings from System B than they were taking from System A ?&nbsp; I have a attached a sample document.</P><P></P><P>So , for example, in the attached document if we take <EM><STRONG>today's</STRONG> </EM>date as 28/01/2017, we can see that User C has taken 5 bookings from System A but going forward User C has taken 7 bookings from System B.</P><P><IMG __jive_id="179050" alt="past_future_ratio.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179050_past_future_ratio.PNG" style="height: auto;" /></P><P></P><P>Is there any suitable way to show this graphically as a number Users' per day going forward compared to the past (as a % or ratio)?</P><P></P><P>Thanks for any help or suggestions!</P><P>Phil</P></BODY></HTML> Mon, 09 Oct 2017 19:31:15 GMT https://community.qlik.com/t5/QlikView/Check-for-Previous-Instances/m-p/1419706#M428491 prees959 2017-10-09T19:31:15Z Re: Check for Previous Instances https://community.qlik.com/t5/QlikView/Check-for-Previous-Instances/m-p/1419707#M428492 <HTML><HEAD></HEAD><BODY><P>no one? </P><P></P><P>(sorry for the bump!)</P></BODY></HTML> Wed, 11 Oct 2017 11:01:26 GMT https://community.qlik.com/t5/QlikView/Check-for-Previous-Instances/m-p/1419707#M428492 prees959 2017-10-11T11:01:26Z