topic Re: Section access and where clause in QlikView

Section access and where clause

qlikviewaf — Wed, 14 Feb 2018 10:46:13 GMT

Hi,

i build my security matrix on excel - the goal is to have just one excel for several application

SECTION ACCESS;

LOAD

APPLICATION,

ACCESS,

NTNAME,

SECURITYFIELD

FROM [\\seme004\EMEA\Transversal\JDE Support\QV.QlikView\SecurityMatrix.xlsx](ooxml, embedded labels, table is SecurityMatrix) WHERE (APPLICATION='Securities') ;

On the where condition i would like to specify the application (in the example i'm loading just securiities for the application called "Securities"). The issue is that when the where clause is specified no lines is fetched.

I assume is because i'm using SECTION ACCESS that doens't allow to use where clause. I'm correct? How this can be build then?

Thank you

Re: Section access and where clause

prma7799 — Wed, 14 Feb 2018 10:51:59 GMT

You need to use UPPER() in where clause..

QS automatically converts fields to upper-case even if they're not being used in the table.

Re: Section access and where clause

tresB — Wed, 14 Feb 2018 10:56:28 GMT

Not exactly. The actual reason may be - you can't see the loaded section access table, because it gets dropped immediately after the load completes. Or, if you are talking about - you see 0 lines fetched message in load progress window, it could just be that the condition in where clause is not satisfying (may be because of case mismatch as already pointed out by PM above).

Re: Section access and where clause

_armoco_ — Thu, 21 Mar 2019 07:14:02 GMT

Did you find a solution for this?

Re: Section access and where clause

Shlomoax — Thu, 04 May 2023 11:56:54 GMT

I had the same problem and this was the solution (I used the UPPER() function). Thank you!