topic Re: Active Count of As Of Now for each year in QlikView

Active Count of As Of Now for each year

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i want to active employee on YoY.

Actually I m getting only particular year count in bar chart.

What i want is For example,

Now we are in 2017 ,as of now total is 1552 in text box i m getting, that is fine.But if i take year dim and Take same expression its now giving me . Anyhow if i create Year wise expression that will work.after we require for drill down for year and Month, For that how can i achieve it ?

Please help me oin this.....

Re: Active Count of As Of Now for each year

Thu, 02 Mar 2017 06:09:54 GMT

Hi Subbareddy,

Could you be little more clear on what you want to see as output .

The text box value you see is irrespective of the year (in case if you haven't selected any year).

Re: Active Count of As Of Now for each year

subbareddykm — Thu, 02 Mar 2017 06:22:15 GMT

No,

My result should be like

For 2017 -1552 i.e if you filter in text box with StartDate<=today this 1552 will get

For 2016 ,filter <=2016 max date

like for all years

i hope you you got it.

Re: Active Count of As Of Now for each year

tresB — Thu, 02 Mar 2017 07:38:02 GMT

I am not sure if this is directly doable in the front-end or not. However, just playing in the script a bit you may get your desired output.

Re: Active Count of As Of Now for each year

subbareddykm — Thu, 02 Mar 2017 08:53:01 GMT

Hi,

result Is not correct except for 2017.

Re: Active Count of As Of Now for each year

tresB — Thu, 02 Mar 2017 09:59:42 GMT

What are expected out put for other years (with logic please)?

Re: Active Count of As Of Now for each year

subbareddykm — Thu, 02 Mar 2017 10:16:44 GMT

I have crated for each year,

Using like below expression:(this is 2016)

=fabs(Count({<[Start Date]={"<=$(=Date(AddYears(YearStart(Today())-1,0),'YYYY-MM-DD'))"},Flag={'Total'}>}DISTINCT ID)

-Count({<[Start Date]={"<=$(=Date(AddYears(YearStart(Today())-1,0),'YYYY-MM-DD'))"},Flag={'Sep'}>}DISTINCT ID))

other years i just changed addyears number

Re: Active Count of As Of Now for each year

tresB — Thu, 02 Mar 2017 11:09:27 GMT

Please find attached a solution using The As-Of Table .