Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shalbeguidewire
Contributor
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
Vegar
MVP
MVP

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.

 

shalbeguidewire
Contributor
Contributor
Author

Hi,

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

Regards,

Sameer

 

Vegar
MVP
MVP

It doesn't matter where you do it as long as the final Section access table and fields are in upper case.