YTD Calculation in script

vmurugananthan — Sat, 16 Nov 2024 18:33:38 GMT

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.

Re: YTD Calculation in script

Nicole-Smith — Mon, 01 Jun 2020 20:01:53 GMT

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/

topic Re: YTD Calculation in script in QlikView

YTD Calculation in script

Re: YTD Calculation in script