Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis User Name by Selected Year

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

1 Solution
16 Replies
YoussefBelloum
Champion
Champion

Hi,

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

Anonymous
Not applicable
Author

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

Capture.PNG

YoussefBelloum
Champion
Champion

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

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

Anonymous
Not applicable
Author

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
Not applicable
Author

Hi Youssef,

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

Farrukh

YoussefBelloum
Champion
Champion

for me the problem is here:

problem.png

Anonymous
Not applicable
Author

Hi Sunny,

Please see the attached sample file.

Farrukh