topic REC-QUEST in QlikView

REC-QUEST

Wed, 11 Jun 2014 06:01:23 GMT

Hi Team

1,what is the difference between publisher and section acess?

2.can we use if condtions in expressions instead of set analysis?

3.what is relative schema?

can any one send me answers for the above quest

Re: REC-QUEST

Wed, 11 Jun 2014 06:16:02 GMT

we can use if statement in expression but we can't use if statement instead of set analysis

section access provide the authentication to persons in the scripting level but in publisher we can provide the samething and much more

Re: REC-QUEST

Wed, 11 Jun 2014 06:39:05 GMT

Hi Manoj

1.Publisher can used for distribution of application ,distribution of qlikview report,sending and email along with reduction of dashboard on any particular field or bookmark as well as you can implement security using publisher

Steps:-

Management console-Section access management-either click on default or create new one-edit column-add the column as per our requirement -ok then go to

Edit Script- insert -section access- publisher authentication -copy publisher link and paste ok next

where as

Section access is only used for the implementing security either on sheet level ,document level or object level

Steps:-

Edit Script- insert -section access- inline -it open -add column as per your requirement

2. Yes, we can use if condition in expression for example

Instead of below mention set expression

=sum({<Year={'2012'}>}Sales)

we can use this if statement:-

if(Year=2012,sum(sales)) or =sum(if(Year=2012,Sales))