Skip to main content
Announcements
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
cancel
Showing results for 
Search instead for 
Did you mean: 
AboodSaad
Contributor
Contributor

List all users with their custom properties in dashboard

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.

AboodSaad_0-1601991027077.png

 

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

 
 
 
 
 
 

image.png

 

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.

Labels (3)
1 Solution

Accepted Solutions
QFabian
Specialist III
Specialist III

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";

QFabian

View solution in original post

3 Replies
QFabian
Specialist III
Specialist III

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";

QFabian
AboodSaad
Contributor
Contributor
Author

It worked fine.

Thank you

E_Langlet
Partner - Contributor II
Partner - Contributor II

Hi! 

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

E_Langlet_0-1662991220417.png