Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to add SQL query instead of XLs to my section access.
When I add the query it wont apply the section access.
My table is exact replica of my excel.
Thanks,
Sameer
You write that the table is the same as your excel sheet, but have you made sure that the output of you section access SQL query is the same as your excel. If not, try to load the Section Access table as normal tables to verify that the output is as expected.
Is it possible for you to share the Section Access script?
Is your field names and field values used in the section access in UPPER CASE? If not please make sure they are.
Do you expect the Section Access values to be numeric values starting with inital zeroes like 0000123 or 099999? Some times Qlik are automaticly converting numbers with leading zeros into digits without 000123 becomes 123 and 099999 becomes 99999.
Hi,
The output matches the XLs. Should I do the upper in SQL query or Qlik Load ?
Regards,
Sameer