Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I'm facing and issue with section acces. There is something wrong with my script and I keep receiving access denied.
I'm fetching data dynamically from redshift (user ir, fields etc).
Row looks like this
grp2_code having value 2100, cannot have metric_code equal fte or fte_plan
metric_code having value fte / fte_plan, have no grp2_code (it's empty in my qlik model).
My goal is to filter out all fields containing grp2_code = 2100 and fields containing metric_code = fte or fte_plan.
Here is my code.
This data lies in FCT_MAIN.
If I remove either metric_code or grp2_code, it works and filters fields based on one condition. However I need these two conditions. How can I make it working?
section access is nothing more then a hidden table managing access rights.
what you could do is create this table but not as section access but as a table that everybody can see (just for tetsing) after that see if you, or the user that is accessing redshift is in that table.
also make sure that the qlik serverces are in the access table with full rights. if those don't got rights it will never work if you schedule this app