topic Re: see multiple version of field values in QlikView https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733877#M670149 <HTML><HEAD></HEAD><BODY><P>I am loading the data from Excel. user has access to Excel and user can open the excel file and change the value wherever cell value they want.</P><P></P><P>those time I want to capture the previous values and store in qlivkview.</P><P></P><P>Please advice how to implement this in qlikview</P></BODY></HTML> Fri, 31 Oct 2014 04:45:29 GMT Anonymous 2014-10-31T04:45:29Z see multiple version of field values https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733873#M670140 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am new to qlikview and developing the dashboard. One of the requirement of the customer is that they want see or compare the multiple version of some field values.</P><P></P><P>Can you pleas advice how to implement in this qlikview.</P><P></P><P>regards</P><P>Ramu</P></BODY></HTML> Thu, 30 Oct 2014 13:31:25 GMT https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733873#M670140 Anonymous 2014-10-30T13:31:25Z Re: see multiple version of field values https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733874#M670142 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you can use alternate states.</P><P></P><P>Check for the example in the dashboard "Whats New in QlikView11.qvw" in your system .</P><P>C:\Program Files\QlikView\Examples\Documents (if you have installed qlikview in your system).</P></BODY></HTML> Thu, 30 Oct 2014 13:33:54 GMT https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733874#M670142 2014-10-30T13:33:54Z Re: see multiple version of field values https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733875#M670144 <HTML><HEAD></HEAD><BODY><P>A standard list box will expose all the unique values within any field in your data set. </P><P></P><P>You can also add expressions to the list box to see a numerical breakdown of any measure in your data set for comparative purposes. At some point it makes sense to use a chart instead.</P><P></P><P>A screenshot example of what you are trying to achieve would be helpful.</P></BODY></HTML> Thu, 30 Oct 2014 13:34:25 GMT https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733875#M670144 JonnyPoole 2014-10-30T13:34:25Z Re: see multiple version of field values https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733876#M670147 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Can you plz elaborate your qequirement.</P><P>what is the field values version?</P></BODY></HTML> Thu, 30 Oct 2014 13:38:52 GMT https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733876#M670147 2014-10-30T13:38:52Z Re: see multiple version of field values https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733877#M670149 <HTML><HEAD></HEAD><BODY><P>I am loading the data from Excel. user has access to Excel and user can open the excel file and change the value wherever cell value they want.</P><P></P><P>those time I want to capture the previous values and store in qlivkview.</P><P></P><P>Please advice how to implement this in qlikview</P></BODY></HTML> Fri, 31 Oct 2014 04:45:29 GMT https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733877#M670149 Anonymous 2014-10-31T04:45:29Z Re: see multiple version of field values https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733878#M670150 <HTML><HEAD></HEAD><BODY><P>Hi Ramu,</P><P></P><P>I hope users will not updating the same row but will be entering the changed data in one more row.</P><P>In that case, you'll be having the previous data as well.</P><P>But make sure you have one more column(new) to have distinct values.</P><P></P><P>In this way, you can have the previous values as well.</P><P></P><P>Hope this is clear. If I understand your question in another way, please elaborate your issue.</P><P></P><P></P><P></P><P>Cheers,</P><P>Naresh</P></BODY></HTML> Fri, 31 Oct 2014 05:04:48 GMT https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733878#M670150 NareshGuntur 2014-10-31T05:04:48Z Re: see multiple version of field values https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733879#M670151 <HTML><HEAD></HEAD><BODY><P>Check these links</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions">http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions</A></P><P><A href="https://community.qlik.com/docs/DOC-4310">IntervalMatch and Slowly Changing Dimensions</A></P></BODY></HTML> Fri, 31 Oct 2014 05:39:37 GMT https://community.qlik.com/t5/QlikView/see-multiple-version-of-field-values/m-p/733879#M670151 anbu1984 2014-10-31T05:39:37Z