ytd and previous on single date

[harsha087]

Hi All,,

In the below table, i have date as dimension and two measures (19/20 and ytd) . 

i need to get the previous year data for a particular period as well as  current period .

in the above table , for 08/04/20 .. 19/20 should show the sum of sales happened on 08/04/2019  and in ytd it should show the sum of sales happened on 08/04/20. 

please can anyone help me 

[sunny_talwar]

I suggest creating The As-Of Table in the script to handle this in a most efficient manner

[harsha087]

i am unable to do it .. 

do u you help me reference example or code 

[sunny_talwar · Accepted solution]

Here is an example

https://community.qlik.com/t5/QlikView-App-Dev/Using-AsOf-table-for-accumulation/td-p/100676