Set Analysis User Name by Selected Year

[Anonymous]

Hi All,

I am trying to count  by selected year where the "Created" year equal to YEAR.

Currently using the calculated dimension as below:

=Aggr(Only({$<Year={"$(=Date(Created,'YYYY')"}>} [User Name]), [User Name])

Expression:

Count([AR ID])

But its returning me null.

Can you please advise where I am having the issue.

Please see the attached sample qvw file.

Thanks & Regards,

Farrukh

[YoussefBelloum]

Hi,

it will not work because your User name and AR_ID are not linked..

[Anonymous]

Hi Youssef,

AR_ID is not a key value, the key Value is "CREATED" field. which is linked to master calendar.

Farrukh

[sunny_talwar]

May be you need Lower function in your tblInfoPathUsers table also

[YoussefBelloum]

When I say Linked I'm not talking about joining keys..

on your data, every User name don't have any AR_ID.

[Anonymous]

Hi Sunny,

I have put the lower function but still no luck.

The problem I am having with Year field. When I select Year then in a char its calculate 0. When I remove year selection then its show "//Error in calculated dimension".

Can you please see the calculated dimension? I do not know where I am having the issue in syntax.

[sunny_talwar]

Can you attach the new app where you have fixed the issue related to lower?

[Anonymous]

Hi Youssef,

There are only 3 ARID where the user is not assigned. every single record has the AR ID

Farrukh

[YoussefBelloum]

for me the problem is here:

[Anonymous]

Hi Sunny,

Please see the attached sample file.

Farrukh