Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to filter Data In ListBox

hello dears

i want filter Data In ListBox Look like (Dimension Limitation in Chart)

i want show The last two records Of  Ten record

Please Help Me

Untitled.png

1 Solution

Accepted Solutions
ganeshreddy
Contributor III

Re: How to filter Data In ListBox

Hi Leila,

You can add following expression in list box properties.

if(match(year,'369606','3696907'),year)


Capture.PNG

Please find the attached QVW for refrence


Best regards,

Ganesh Reddy

4 Replies

Re: How to filter Data In ListBox

What do you mean by last two records for Ten records? I can see there are many values in listbox

arulsettu
Honored Contributor III

Re: How to filter Data In ListBox

if you want to show that two records means try this

if(match(year,'369606','3696907'),year)

ganeshreddy
Contributor III

Re: How to filter Data In ListBox

Hi Leila,

You can add following expression in list box properties.

if(match(year,'369606','3696907'),year)


Capture.PNG

Please find the attached QVW for refrence


Best regards,

Ganesh Reddy

parthakk
Contributor II

Re: How to filter Data In ListBox

Hi,

I could not find option in list box. But a similar view like list box can be obtained

PFA

Thanks,

Partha Kulkarni