topic Re: Autonumber in Combined Key in Section Access in QlikView

Autonumber in Combined Key in Section Access

manishnarang — Mon, 20 Apr 2015 13:06:01 GMT

HI All,

in an application, i have section access implemented based on two Text Fields.

I understand that i need to:

1. Make the keys in UPPER case in Section Access

2. As well as in Section Application

which doesn't look very nice on the UI though, but still works fine for now.

I just wanted to use a combined key (which becomes a long text key) and assign it a numeric value using AutoNumber() function.

so i have

Autonumber(Col1&Col2) as Key

in Section Access as well as in Data tables.

But this does not seem to work. it does not let me open the dashboard in Access Point.

To me, it seems like Autonumber is assigning numbers to combinations loaded in Section Access and then continuing that counter in the Data. But just a guess.

Anyone has any insights from prior experiences?

Best, Manish

Re: Autonumber in Combined Key in Section Access

rubenmarin — Mon, 20 Apr 2015 13:12:44 GMT

Hi Manish, try to use KEY (all upercase) as field name.

Also you can test first if this works without autonumber.

Re: Autonumber in Combined Key in Section Access

manishnarang — Mon, 20 Apr 2015 16:46:22 GMT

Hi Ruben,

That i have already tried and it works fine.. I just wanted to use the same concept we use to remove synthetic keys.. make a combined key and use a autonumber() on that.. to make the joins faster.. i though i could make the initial reduction faster by doing the above stated.

anyone else, any thoughts please ?

Best, Manish

Re: Autonumber in Combined Key in Section Access

rubenmarin — Mon, 20 Apr 2015 17:19:48 GMT

Hi Manish, you tried the first part of my post? using KEY as field name, all uppercase, in section access and section application.

Re: Autonumber in Combined Key in Section Access

ziadm — Mon, 20 Apr 2015 17:31:45 GMT

Syntax:

AutoNumber (expression [, AutoID])

Try using the AutoID parameter as KeyID

Example:

LOAD AutoNumber (Col1& Col2, 'KeyID') AS KEY_FIELD

Re: Autonumber in Combined Key in Section Access

manishnarang — Mon, 20 Apr 2015 18:39:46 GMT

No Ziad, it didn't work with KeyID as second parameter.

Has anyone used AutoNumber() with Section Access?

Re: Autonumber in Combined Key in Section Access

rubenmarin — Mon, 20 Apr 2015 19:24:09 GMT

If using all uppercased field name still doesn't works can be because autonumber uses a different lookup table when changing sections (just guessing), creating all autonumber in the same section can avoid the issue, something like this:

Section application;

Your actual section application...

Access: //Inside section application

LOAD Autonumber(Col1&Col2) as KEY, otherFields...

Section access;

Security:

LOAD * Resident Access;

Section application;

DROP Table Access;

Re: Autonumber in Combined Key in Section Access

ziadm — Tue, 21 Apr 2015 00:05:15 GMT

Hi Kumar

Not able to open the dash board mean you are not being granted the access and this should not be Autonumber is the problem .. How about the ADMIN is he able to access the Dashboard.

Please post a sample of the section access code in here. Sometimes leaving commas out will be ignored by Qlik compiler and you think that security access is ok

please post a sample of the security access

Re: Autonumber in Combined Key in Section Access

manishnarang — Tue, 21 Apr 2015 06:56:06 GMT

Hi Ruben,

Implemented the way you said. unfortunately i can't copy the code/data here. i will create a sample application with dummy data and will post here for your suggestions.

Just FYI, After implementing the above, It didn't simply kick me out but started asking for UserName and Password, whereas I am using NTNAME in section access. Not sure what changed internally.

Anyways, thanks ,, will post the sample app and data soon.

thanks..