Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

shalbeguidewire
New Contributor

Section access works with XLS but wont work with SQL

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

 

 

3 Replies
Partner
Partner

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
???
shalbeguidewire
New Contributor

Re: Section access works with XLS but wont work with SQL

Hi,

The output matches the XLs. Should I do the upper in SQL query or Qlik Load ?

Regards,

Sameer

 

Partner
Partner

Re: Section access works with XLS but wont work with SQL

It doesn't matter where you do it as long as the final Section access table and fields are in upper case.
???
Celebrating my 300 accepted solution in the Qlik Community
???