topic Re: Section access not reducing crosstable fields..help? in QlikView

Section access not reducing crosstable fields..help?

gauthamchilled — Tue, 30 Jun 2015 06:04:01 GMT

Hi, I have the following script. I want abc user to see only Weight as a measure. but abc user is able to see all the measure here in the attached the application. kindly help how to reduce the field

SECTION ACCESS;

LOAD * INLINE
[
ACCESS,USERID,PASSWORD,upper(Measure)
ADMIN,ADMIN,ADMIN,*,
USER,abc,abc,Weight];

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SECTION APPLICATION;

CrossTable(Measure, Data)
LOAD Id,
[Volume l.],
Weight
FROM

(ooxml, embedded labels, table is Sheet1);

Re: Section access not reducing crosstable fields..help?

MK_QSL — Tue, 30 Jun 2015 06:13:57 GMT

Try like this...

SECTION ACCESS;

LOAD * INLINE

[

ACCESS,USERID,PASSWORD,MEASURE

ADMIN,ADMIN,ADMIN,*,

USER,ABC,ABC,WEIGHT

];

SECTION APPLICATION;

CrossTable(MEASURE, Data)

LOAD Id,

[Volume l.],

Weight

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Section access not reducing crosstable fields..help?

Siva_Sankar — Tue, 30 Jun 2015 06:19:59 GMT

Manish,

I changed to upper case still not working,.

Re: Section access not reducing crosstable fields..help?

gauthamchilled — Tue, 30 Jun 2015 06:22:06 GMT

Yes, Even I tried it. find the app

Re: Section access not reducing crosstable fields..help?

MK_QSL — Tue, 30 Jun 2015 06:30:36 GMT

Try exactly what I wrote...!

Re: Section access not reducing crosstable fields..help?

gauthamchilled — Tue, 30 Jun 2015 06:41:55 GMT

Hi,

I just copied your code and pasted it. Now I cant even open as user abc but I can able to see as admin. Can you point me where I am wrong>?

Re: Section access not reducing crosstable fields..help?

avinashelite — Tue, 30 Jun 2015 06:49:39 GMT

Hi ,

As I observe in the section access part for the Measure column you dont have any data that 's why its not allowing to see the data .

Try to add some data in the Measure column for abc and then check it will surely work

Re: Section access not reducing crosstable fields..help?

avinashelite — Tue, 30 Jun 2015 06:53:04 GMT

try like this :

SECTION ACCESS;

LOAD * INLINE

[

ACCESS,USERID,PASSWORD,MEASURE

ADMIN,ADMIN,ADMIN,*,

USER,ABC,ABC,WEIGHT

];

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;-$#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SECTION APPLICATION;

CrossTable(MEASURE, Data)

LOAD Id,

[Volume l.],

Weight as WEIGHT

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Section access not reducing crosstable fields..help?

MK_QSL — Tue, 30 Jun 2015 08:18:07 GMT

SECTION ACCESS;

LOAD * INLINE

[

ACCESS, USERID, PASSWORD, MEASURE

ADMIN, ADMIN, ADMIN, *

USER, ABC, ABC, WEIGHT

DUMMY, DUMMY, DUMMY, VOLUME

];

SECTION APPLICATION;

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;-$#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

CrossTable(MEASURE, Data)

LOAD

Id,

UPPER(Volume) as VOLUME,

UPPER(Weight) as WEIGHT

Inline

[

Id, Volume, Weight

1, 123, 100

2, 145, 200

3, 167, 300

];