topic Re: CAN ANY ONE EXPLAIN THIS SCRIPT? in QlikView

CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 13:23:05 GMT

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

];

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 13:28:38 GMT

Hi Madhu

can you share your qvw ?

CHris

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

alexandros17 — Thu, 04 Jun 2015 13:31:09 GMT

you have written

CH01,CHO2

CH zero 1, CH O (letter) 2

is that correct?

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Anonymous — Thu, 04 Jun 2015 13:34:05 GMT

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

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 13:39:17 GMT

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

];

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Anonymous — Thu, 04 Jun 2015 13:39:58 GMT

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

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 13:44:53 GMT

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.

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

nagarjuna_kotha — Thu, 04 Jun 2015 13:47:57 GMT

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

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 13:48:26 GMT

see christianj i attached my qvw .

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 14:05:40 GMT

thank you michael

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 14:13:40 GMT

whatever you explain exactly I want to display according to your explanation but it doesnot work pls tell me solution nagarjuna . I attached everything regarding this application. pls find that screen shots or download my qvw .userid is madhu(admin) user(kalyan) user(ramnath):passwords: madhu password for madhu(admin).kalyan password for kalyan(user) and ramnath password for ramnath(user).

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 14:15:38 GMT

Madhu

is that what you want ?

Chris

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 14:32:39 GMT

I write your expression but it is not working .pls send one small example

regards

madhu

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 14:40:47 GMT

I want to display like below christianj. if i login to kalyan it display only kalyan chart.and if login to ramnath it display only ramnath chart.but when I login to kalyan it also display other user chart information and admin chart information.

SECTION Application;

LOAD * Inline [

USERID,CH01,CHO2

MADHU,1,1

KALYAN,1,0

RAMNATH,0,1

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

Madhu Can access CH01 and CH02

Kalyan Can acccess CH01 only

Ramath can Access CH02 Only.

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 14:43:52 GMT

Madhu,

it is what happens when I connect or click on names

Chris

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 14:44:08 GMT

I attached everything regarding this application. pls find that screen shots or download my qvw .userid is madhu(admin) user(kalyan) user(ramnath):passwords: madhu password for madhu(admin).kalyan password for kalyan(user) and ramnath password for ramnath(user).

I do not open your qvw because I used personal edition.

regards

madhu

CAN ANY ONE EXPLAIN THIS SCRIPT?

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 14:47:12 GMT

Here is the script

And i changed condition > 0

Chris

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Anonymous — Thu, 04 Jun 2015 15:40:49 GMT

Try to open as different users

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 16:24:24 GMT

thankyou christianj. but I can not open your qv document. because I use qlikview personal edition.please christanj send screenshots or explain with example .

Regards

madhu

Re: CAN ANY ONE EXPLAIN THIS SCRIPT?

Thu, 04 Jun 2015 16:56:57 GMT

thank you Christianj .do i use same condition in both charts .condition is sum(ch01)>0.

regards

madhu