topic Calculating YTD Numbers in QlikView

Calculating YTD Numbers

nvrphanikumar — Mon, 23 Jan 2017 18:48:06 GMT

Hi,

Fairly New

Trying to calculate YTD Filled numbers.

At first tried this

COUNT({$<[Current Disposition Status]={'090 Hired'},year([Filled Date]) = {'$(=Year(Today()))'}>} [Application ID])

and learnt that i cant use Functions on the left side.

Tried this

Count(if(Year([Filled Date]) = {$(=Year(Today()))}), [Application ID]))

Still cant get the right values,Can someone please correct where i'm wrong?

MK_QSL — Mon, 23 Jan 2017 18:52:29 GMT

Create FilledYear in script as below

Year([Filled Date]) as FilledYear

Count({<[Current Disposition Status]={'090 Hired'}, FilledYear = {'$(=Year(Today()))'} >}[Application ID])

nvrphanikumar — Mon, 23 Jan 2017 18:54:48 GMT

There are many Metrics for which i need to calculate YTD, Is there a better way than creating the Year Column in the dataset ?

MK_QSL — Mon, 23 Jan 2017 18:57:36 GMT

Provide source data or sample application. Can suggest you something only after checking that..