topic Re: Section Access in QlikView

Section Access

rodrigue_saade — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

i have the following case in section access:

Is there any way to autogenerate the values of RegionID, since the values are well defined for the same user from 01-00-00 till 09-09-09?

ecolomer — Mon, 25 May 2015 13:59:53 GMT

see this

maxgro — Mon, 25 May 2015 18:40:15 GMT

load num(rowno(), '00') as R1 AutoGenerate 9;

join (R) load num(rowno()-1, '00') as R2 AutoGenerate 10;

join (R) load num(rowno()-1, '00') as R3 AutoGenerate 10;

Left join (R) load *, text(R1 & '-' & R2 & '-' & R3) as AllRegion Resident R;

LOAD Distinct

Access,

UserID,

Password

FROM

(html, codepage is 1252, embedded labels, table is @1);

join (S) load AllRegion as Region Resident R;

DROP Table R;

Anonymous — Mon, 25 May 2015 22:03:01 GMT

Not related to your question - but you must use REGIONID instead of RegionID if you want to use it for data reduction.

rodrigue_saade — Mon, 25 May 2015 22:52:32 GMT

Solved!! Thank you Massimo, and Thank you all guys.