This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
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 joinselect "Value", "Definition_ID",
left joinSELECT "ID" as "Definition_ID","Name","ValueType","ChoiceValuesString","ObjectTypesString","CreatedDate","ModifiedDate","ModifiedByUserName","Description"FROM "public"."CustomPropertyDefinitions";
View solution in original post
It worked fine.