Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

CAN ANY ONE EXPLAIN THIS SCRIPT?

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 1111.PNG

last1.PNG

22 Replies
Not applicable

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Hi Madhu

can you share your qvw ?

CHris

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

you have written

CH01,CHO2

CH zero 1, CH O (letter) 2

is that correct?

balkumarchandel
Valued Contributor II

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

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

Not applicable

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

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

];

mov
Esteemed Contributor III

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

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

Not applicable

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

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
Valued Contributor II

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

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.................

Not applicable

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

see christianj i  attached my qvw .

Not applicable

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

thank you michael

Community Browser