Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
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 II
Specialist II

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

2 Replies
QFabian
Specialist II
Specialist II

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