https://community.qlik.com/t5/QlikView/Display-Prior-Year-values-by-Current-Year-Dates-without/m-p/1823717#M1213795 <P>I would like to display Current Year values and Prior Year values on the same row as the current year's dates.</P><P>For Example (on 7/21/2021, sales are $1000... on 7/21/2020, sales were $500)</P><P><STRONG>Date (as a dimension)&nbsp; &nbsp;|&nbsp; &nbsp; CY Sales&nbsp; &nbsp;|&nbsp; &nbsp; PY Sales</STRONG></P><P>07/21/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp;$1000&nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;$500</P><P>&nbsp;</P><P>How do I achieve this without scripting?</P> Wed, 21 Jul 2021 18:29:49 GMT benvatvandata 2021-07-21T18:29:49Z https://community.qlik.com/t5/QlikView/Display-Prior-Year-values-by-Current-Year-Dates-without/m-p/1823717#M1213795 <P>I would like to display Current Year values and Prior Year values on the same row as the current year's dates.</P><P>For Example (on 7/21/2021, sales are $1000... on 7/21/2020, sales were $500)</P><P><STRONG>Date (as a dimension)&nbsp; &nbsp;|&nbsp; &nbsp; CY Sales&nbsp; &nbsp;|&nbsp; &nbsp; PY Sales</STRONG></P><P>07/21/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp;$1000&nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;$500</P><P>&nbsp;</P><P>How do I achieve this without scripting?</P> Wed, 21 Jul 2021 18:29:49 GMT https://community.qlik.com/t5/QlikView/Display-Prior-Year-values-by-Current-Year-Dates-without/m-p/1823717#M1213795 benvatvandata 2021-07-21T18:29:49Z