topic condition based data ristriction in QlikView

condition based data ristriction

anuradhaa — Thu, 12 Nov 2015 11:42:24 GMT

Hi,

I have two tables as

sales and agents

In sales and agents has common field agent id

in agents table i have a column called country.

I need to display data in my reports based on country='USA'

Can i do it in front end ( I know we can use set analysis, but then i have to do that in each and every report)

Re: condition based data ristriction

sunny_talwar — Thu, 12 Nov 2015 11:46:15 GMT

You can add a filter (list box) for country field and make a selection on 'USA' and everything in your application (except for places you have restricted it using set analysis) should display you data for 'USA' only.

Re: condition based data ristriction

alexandros17 — Thu, 12 Nov 2015 11:46:19 GMT

You can filter all the data in the script with a where condition (country='USA'), otherwise you can set the country (with a trigger) at the opening of the document. Last option is set analysis

Let me know

Re: condition based data ristriction

anuradhaa — Thu, 12 Nov 2015 11:49:29 GMT

can i set default selection sin list boxes.

Re: condition based data ristriction

anuradhaa — Thu, 12 Nov 2015 11:50:29 GMT

filtering data can't be done because country feild is not available in sales table. can you please explain how to add trigger

Re: condition based data ristriction

sunny_talwar — Thu, 12 Nov 2015 11:50:54 GMT

By default do you mean when you open the application? or do you mean when you press clear?

Both of the options are possible

1)You can set on open trigger

2) You can set the clear state to have USA selected all the time.

Re: condition based data ristriction

sunny_talwar — Thu, 12 Nov 2015 11:53:06 GMT

Even though they come from different tables, you can filter country out if you want

Sales:

LOAD sales,

agent id

FROM table1;

Agent:

Right Keep (Sales)

LOAD agent id,

agent name,

country

FROM table2

Where country = 'USA';

Re: condition based data ristriction

alexandros17 — Thu, 12 Nov 2015 11:55:59 GMT

Go in Settings -> Document Properties - >triggers

Select "On Open" Menu Item then press "Edit Action"

press "Add", select "Select in field" and write:

In the upper box Country, in the lower box USA all without apex ...

let me know

Re: condition based data ristriction

anuradhaa — Thu, 12 Nov 2015 12:06:26 GMT

Thanks all for your contribution

Re: condition based data ristriction

anuradhaa — Thu, 12 Nov 2015 12:10:49 GMT

Hi Your answer also correct. Thank You

Re: condition based data ristriction

sunny_talwar — Thu, 12 Nov 2015 12:44:06 GMT

I am glad we were able to help and you got what you were looking for.