Discussion Board for collaboration related to QlikView App Development.
We are using direct discovery for one of our requirement, we found that -
Data should be filtered w.r.t. logged in user, and we can not use Section access with Direct discovery.
In the View, we have one have one column which will contain username.
Can I have the filter condition in Direct discovery as -
1 As Flag
where username = OSUser();
I want the workaround something like above.
Could you please assist on same.
Thanks & Regards,
Try Something Like this
Note: Please provide does it mandatory to show username as MEASURE. I've added this on DIMENSION Instead of MEASURE. Try Luck if this Works
1 As Flag,
FROM "test_data" where username = "OSUser()";
We are using QV 12 server...
I tried to implement same using direct query like -
'USER' AS ACCESS
Upper(col1) as NTNAME,
Upper(col1) as TEST_NAME
I have also created a same column TEST_NAME and have checked the option of strict exclusion to True.
But its not working.
I am not entirely sure how exactly the direct query can be implemented, but I know the section access in direct query happens through QMC instead of doing it in the QlikView file.
You will need to reload the application. I think the idea for using direct query is to be updated on real time most of the time, but to update the list of users you can quickly reload it on the QMC. A direct query application reloads much faster than a regular application because it only pulls distinct values of DIMENSIONS into memory. So, you can plan to refresh this once a day when you know nobody else will be looking at this application.