Re: Section access works with XLS but wont work with SQL
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.
??? Celebrating my 300 accepted solution in the Qlik Community ???