CAN ANY ONE EXPLAIN THIS SCRIPT?

[#1]

HI,

I CREATED OBJECTLEVEL SECTION ACCESS IN QLIKVIEW BUT I DO NOT UNDERSTAND THIS SCRIPT.ACCORDING TO MY KNOWLEDGE  IN  SCRIPT I  ASSIGN  USER1  KALYAN  SEE ONLY  CHO1 (CHART1) AND RAMNATH SEE ONLY CH02(CHART2) BUT IT DISPLAY OPPOSITE DIRECTIONS .WHEN I SELECT KALYAN IT DISPLAY  CH02(BAR CHART) AT THE SAME TIME WHEN I SELECT RAMNATH IT DISPALY  CH01 (BARCHART CH01).IT DOES NOT DISPLAY CHARTS IN RIGHGTWAY. CAN ANY ONE EXPLAIN  THIS SCRIPT.HELP ME HOW GIVE OBJECT LEVEL SECURITY IN QLIKVIEW.

SECTION Access;

LOAD * Inline [

ACCESS,USERID,Product

ADMIN,MADHU,*

USER,KALYAN,sony

USER,RAM,philips

]

;

SECTION Application;

LOAD * Inline [

USERID,CH01,CHO2

MADHU,1,1

KALYAN,1,0

RAMNATH,0,1

]; 

[#2]

Hi Madhu

can you share your qvw ?

CHris

[alexandros17]

you have written

CH01,CHO2

CH zero 1, CH O (letter) 2

is that correct?

[Anonymous]

Hi ,

This is your condition show part

SECTION Application;

LOAD * Inline [

USERID,CH01,CHO2

MADHU,1,1

KALYAN,1,0

RAMNATH,0,1

]; 

MADHU will see both charts as for both charts he is having 1

KALYAN will see only chart CH01 as he is having 1 only against Chart CH01 etc .

now you need to open Chart properties then 'Layout' tab select 'conditional' in show then write CH01

in chart 1 expression ... now it should work.

Thanks

BKC

[#5]

thank you I write like this  but still it display wrong and one more thing when i login user  kalyan  but it show other user details also.

USERID,CH01,CH02

MADHU,1,1

KALYAN,1,0

RAMNATH,0,1

];LOAD * inline

[

userid,product,price

kalyan,sony,40000

ram,philips,50000

];

[Anonymous]

There is no need for Section Access for the "object level security", but since you have it, you can use it.  Set "show condition" in chart 1:
match(QVUser(), 'MADHU','KALYAN')
In chart 2:
match(QVUser(), 'MADHU','RAMNATH')

Besides:
Your Section Access has field Product, which tells me that you want to limit user access to the products.  You have to use upper case:

Section Access;
LOAD * Inline [
ACCESS,USERID,PRODUCT
ADMIN,MADHU,*
USER,KALYAN,SONY
USER,RAM,PHILIPS];

And, you need field PRODUCT also in Section Application.

And - please don't use all caps in your post, it feels like you're shouting... .  And harder to read

[#7]

in layout tab I wrote expression like this =Sum(CH02)>1 balkumar.here I faced   one more problem.when i login to user kalyan it show admin (madhu)chart and other user chart details also.pls send  to me   another example .how to create object level section access in qlikview.

[nagarjuna_kotha]

As per ur question

******************************************

SECTION Application;

LOAD * Inline [

USERID,CH01,CHO2

MADHU,1,1

KALYAN,1,0

RAMNATH,0,1

************************************************

Madhu  Can access CH01 and CH02

Kaltan Can acccess CH01 only

Ramath can Access CH02 Only.

But one thing i want to tell u is there is a mistake in data in User.

KINDLY LET ME KNOW IF U NEED ANY FROM.................

[#9]

see christianj i  attached my qvw .

[#10]

thank you michael