topic Problem solving for constant moving targets in QlikView https://community.qlik.com/t5/QlikView/Problem-solving-for-constant-moving-targets/m-p/1252249#M396194 <HTML><HEAD></HEAD><BODY><P>Dear Qlikview User</P><P></P><P>I have spent many hours in the last few days trying to solve some problems I have with regards to displaying Targets in a table</P><P></P><P>My problem lies with the fact that month on month the targets can change and I am having difficulty solving 3 issues with regards to this</P><P></P><P>I have attached a QVW which contains dummy data, but the data is in the exact structure in which I am receiving it.</P><P></P><P>I was wondering if you could kindly point me in the right direction of how to solve some of the problems. I don't expect anyone to solve them all for me, but I have a feeling that one problem may solve another one</P><P></P><P>If you have the time to take a look, then that would be great!</P><P></P><P>Kind Regards</P><P>Helen</P></BODY></HTML> Sun, 29 Jan 2017 16:22:40 GMT helen_pip 2017-01-29T16:22:40Z Problem solving for constant moving targets https://community.qlik.com/t5/QlikView/Problem-solving-for-constant-moving-targets/m-p/1252249#M396194 <HTML><HEAD></HEAD><BODY><P>Dear Qlikview User</P><P></P><P>I have spent many hours in the last few days trying to solve some problems I have with regards to displaying Targets in a table</P><P></P><P>My problem lies with the fact that month on month the targets can change and I am having difficulty solving 3 issues with regards to this</P><P></P><P>I have attached a QVW which contains dummy data, but the data is in the exact structure in which I am receiving it.</P><P></P><P>I was wondering if you could kindly point me in the right direction of how to solve some of the problems. I don't expect anyone to solve them all for me, but I have a feeling that one problem may solve another one</P><P></P><P>If you have the time to take a look, then that would be great!</P><P></P><P>Kind Regards</P><P>Helen</P></BODY></HTML> Sun, 29 Jan 2017 16:22:40 GMT https://community.qlik.com/t5/QlikView/Problem-solving-for-constant-moving-targets/m-p/1252249#M396194 helen_pip 2017-01-29T16:22:40Z Re: Problem solving for constant moving targets https://community.qlik.com/t5/QlikView/Problem-solving-for-constant-moving-targets/m-p/1252250#M396195 <HTML><HEAD></HEAD><BODY><P>Why cant you create a Autonumber(Metric&amp;FactDate) AS %KeyField</P><P>Create this in both your table Dim table and Target table and rename the fields in each tables which are same.</P><P></P><P>IF possible can you share your sample excel files as well to work on script and reload data. ?</P></BODY></HTML> Sun, 29 Jan 2017 19:09:05 GMT https://community.qlik.com/t5/QlikView/Problem-solving-for-constant-moving-targets/m-p/1252250#M396195 vishsaggi 2017-01-29T19:09:05Z