Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sonysree88
Creator II
Creator II

limit

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?

15 Replies
Anonymous
Not applicable

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])

Listbox expression.JPG

Anonymous
Not applicable

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

Anonymous
Not applicable

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

sonysree88
Creator II
Creator II
Author

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

vishsaggi
Champion III
Champion III

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

Anonymous
Not applicable

sonysree88




i am looking to get same information as vishsaggi asked.