YTD Calculation in script

[vmurugananthan]

Hi,

I have the following dataset:

Date	Claim Number	Processing Status	Injury Type
25-05-2020	1	P	Severe
25-05-2020	2	NP	Minor
01-06-2020	3	P	Severe
08-06-2020	4	NP	Severe
08-06-2020	5	P	Minor
15-06-2020	6	NP	Severe
15-06-2020	7	NP	Severe
15-06-2020	8	NP	Severe

I want to calculate YTD numbers for:

1. total processed (Count of claims with Processing status as P)

2. % processed (Count of claims with Processing status as P / all claims)*100

3. Total number of severe injuries

I tried many methods like AsOfTable, Using RangeSum and Above combinations etc. All these works but the problem is I need to have a date filter in my dashboard. So when i select a particular date, the data is shown only for that date but i want it to be from the start of the year. 

Any idea on how to implement this @sunny_talwar @swuehl  or anyone else from the community? Thanks in advance.

[Nicole-Smith]

Your post has been replied to on the other thread.  Please do not post the same thing multiple times.

https://community.qlik.com/t5/QlikView-App-Development/Calculation-of-YTD-in-script/m-p/1707236/