Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
Hi Madhu
can you share your qvw ?
CHris
you have written
CH01,CHO2
CH zero 1, CH O (letter) 2
is that correct?
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
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
];
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
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.
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.................
see christianj i attached my qvw .
thank you michael