topic ytd and previous on single date in App Development

ytd and previous on single date

harsha087 — Tue, 30 Nov 2021 16:25:32 GMT

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

Re: ytd and previous on single date

sunny_talwar — Mon, 13 Sep 2021 12:23:00 GMT

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

Re: ytd and previous on single date

harsha087 — Wed, 15 Sep 2021 06:06:15 GMT

i am unable to do it ..

do u you help me reference example or code

Re: ytd and previous on single date

sunny_talwar — Thu, 23 Sep 2021 13:15:23 GMT

Here is an example

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