topic Re: Limiting Items in a List Box in QlikView

Limiting Items in a List Box

Mon, 20 Jan 2014 03:23:34 GMT

I have a view with the following list box:

This view is going to be a Global View that I don't want to limit the items in the list box. I need to then create 6 tabs for each of the items in my Industry list above. Is there a way to limit those views? In other words when you select the Public K-12 tab I only want to show Public K-12 as the Industry. The reason for this is I have 7 teams. One that will see everything and one for each of the Industries listed. If I am on the Public K-12 I only need to see Public K-12. I hope this makes sense.

David

Re: Limiting Items in a List Box

vikasmahajan — Mon, 20 Jan 2014 03:54:04 GMT

Try to Implement Section Access , Data Will see by there functions using this

Vikas

Re: Limiting Items in a List Box

jagan — Mon, 20 Jan 2014 04:09:49 GMT

Hi David,

Implement Section Access for your Dashboard. Please check the below script or refer Qlikview Help (F1) file for more details and examples

Find the script below which implements the Section Access based on the Users department.

If the user has access to department 1 then he can see only his department data. We need to give the password if the user is custom.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REDUCTION

ADMIN, Admin, password, *

USER, Sales, password1, 1

USER, Market, password1, 2

];

Section Application;

star is *;

Departments:

LOAD * INLINE [

REDUCTION, Dept,

1, Sales

2, Marketing];

Sales:

LOAD * INLINE [

Dept, Sales

Sales, 100

Sales, 200

Sales, 4646

Sales, 755

Sales, 422

Sales, 42

Marketing, 2

Marketing, 453

Marketing, 54

Marketing, 45

];

Hope the script helps you in understanding.

Regards,

Jagan.

Re: Limiting Items in a List Box

Mon, 20 Jan 2014 04:18:20 GMT

Create a flag for all industry values and when ever you have on that tab, select that industry flag value by using triggers.

Re: Limiting Items in a List Box

prasad_dumbre — Mon, 20 Jan 2014 04:31:09 GMT

Hi,

If you dont want to use section acess, then by using conditions based on variables triggers u can solve this scenario. . .

Re: Limiting Items in a List Box

Mon, 20 Jan 2014 11:50:15 GMT

Can you provide with an example of how this done? I want to try it before using Section Access.

Re: Re: Limiting Items in a List Box

vikasmahajan — Mon, 20 Jan 2014 11:53:43 GMT

PFA documents with user admin & pass admin1

Vikas