List all users with their custom properties in dashboard

[AboodSaad]

Hi. I am very new to Qlik sense, and I have this scenario that I want to implement. 

I have created an AppLevel custom property.

And then I assigned the custom property values for each user.

I just want to list each user with all his/her AppLevel values in a dashboard.

Is there a way that I can retrieve such data from the QMC?

Thank you.

[QFabian · Accepted solution]

Hi, i just made this script, and works good, remenber to create the PostgreSQL conection to your own QlikSense Repository

Code starts here :

LIB CONNECT TO 'QSR (fabian_fabian)';

User:
LOAD ID as User_ID,
UserId,
UserDirectory;
SELECT "ID",
"UserId",
"UserDirectory"
FROM "public"."Users"
where "Users"."UserDirectory" <> 'INTERNAL';

left join
select
"Value",
"Definition_ID",

"User_ID"
FROM "public"."CustomPropertyValues";

left join
SELECT "ID" as "Definition_ID",
"Name",
"ValueType",
"ChoiceValuesString",
"ObjectTypesString",
"CreatedDate",
"ModifiedDate",
"ModifiedByUserName",
"Description"
FROM "public"."CustomPropertyDefinitions";

[AboodSaad]

It worked fine.

Thank you

[E_Langlet]

Hi! 

Is it also possible to list the licens type that is allocated in Custom Properties?