topic Re: limit in QlikView

limit

sonysree88 — Wed, 25 Nov 2020 16:16:04 GMT

I have a listbox with 30 or so values which I want to limit to 20. This means that only these 20 values should be pre-selected. Is this possible?

Re: limit

squeakie_pig — Wed, 27 Jul 2016 13:53:27 GMT

You can use an expression in the listbox field to limit the values to the 20 that you want.

Re: limit

danansell42 — Wed, 27 Jul 2016 13:56:39 GMT

A similar question was previously posted on the forums

Limited records in List box

Hope this helps

Dan

Re: limit

sonysree88 — Wed, 27 Jul 2016 14:00:40 GMT

It will be helpful to get limit of records but the data is less

If we have have huge data how can we limit..

Re: limit

shree909 — Wed, 27 Jul 2016 14:04:25 GMT

Hi, Create a trigger on opening a sheet. for limiting values on the list box use match function

Select the expression from the drop down of list box and add the below expression.

=if(Match(Field Name,'ABC','Def'),Field Name)

To Pre select these values,on opening the tab, create a sheet level trigger

Open Sheet properties
Select Triggers tab, add action on Activate sheet
Add action, select in field,
add the field name and =if(Match(Field Name,'ABC','Def'),Field Name)

Re: limit

sonysree88 — Wed, 27 Jul 2016 14:21:45 GMT

Hi,

Here you have mentioned like ABC,Def same like i have no of values should limit like upto 40 values how to hide

Its the lengthy process to give the limitation to the listbox

Re: limit

shree909 — Wed, 27 Jul 2016 14:41:15 GMT

Create a variable As vtest and add values separated by comma and enclosed in single quotes

vtest='ABC','DEF','egh'

Add Expression as

=if(Match([Agent Name],$(vtest)),[Agent Name])

Re: limit

Anonymous — Wed, 27 Jul 2016 14:44:41 GMT

share your list box and what you want to limit . That would help us to better assist you

Re: limit

sonysree88 — Wed, 27 Jul 2016 14:59:24 GMT

Hi ,

Please find the attached QVW here am taking Policyname in listbox..

I want to display only 5 policies how can we do can you please give me the answer with screenshots

We can do this by using match function as previously some guys suggested

But if i have 1 Lac records at that time i want to show only 50000 recorders how can do

It would be appreciate if you can help ASAP

Re: limit

sonysree88 — Thu, 28 Jul 2016 13:23:07 GMT

Hello,

Can you Please help me on the above Query limitation of listbox

Re: limit

Anonymous — Thu, 28 Jul 2016 13:41:54 GMT

Here is one of the example on how you can write expression. See the screen shot and expression formula

=if([Policy Type]='Life Insurance',[Policy Name])

Re: limit

Anonymous — Thu, 28 Jul 2016 13:42:36 GMT

Is there any condition for the limitation then let us know we can write the correct expression for you

Re: limit

Anonymous — Thu, 28 Jul 2016 14:28:57 GMT

does that help you or still you have any issues. Please mark if there are any helpful or correct answers so that way it will close the thread and help community members to where to find the answer for

Re: limit

sonysree88 — Thu, 28 Jul 2016 14:44:25 GMT

Hi Vijay,

Thanks for your help..

But am looking to limit the data for that filed only not using another dimensions

You are using like =if([Policy Type]='Life Insurance',[Policy Name])

here policy type and policy name are two different fields ..

Am looking for the below one..

for Ex : Here in policy name filed i have 18 policies but i need top 5 policies how can i get...

Re: limit

vishsaggi — Thu, 28 Jul 2016 14:51:50 GMT

On what criterion you are categorizing those as top 5 policies? There are 18 right, which top 5 you meant here? Any criteria?

Re: limit

Anonymous — Thu, 28 Jul 2016 15:26:12 GMT

sonysree88

i am looking to get same information as vishsaggi asked.