How to filter and show a reduced range of records based on input box

[#1]

Hi,

I'm new to Qlikview and would appreciate any help on the following:

I've a set of records which will be ranked based on sum(Total Value) by Category Name.

I also have an input box whereby user can enter a Category Name, and my chart will have be refreshed to show

only the selected Catagory Name together with 5 other Category Names with sum(Total Value) closest in value to the selected Category Name.

Any advice will be much appreciated.

Thanks!

Weng Kin

Regards

[sujeetsingh]

I didnt get the meaning or context of closest....

In simple you just set a variable to a  input box and try to call that in your chart or table you want..even you can use the set analysis..for thiss,

[nstefaniuk]

Hello,

if it's on open, you can pre-calculate flags in script then use these flags with triggers.

Other solution is :

- user select a category

- user click on a button

- the button

--- - store current category in a variable vCategory

--- - select in a listbox categories where sum(Total Value) = sum({$<Category = {"$(vCategory)"}>}Total Value)

It should work

[nstefaniuk · Accepted solution]

Example attached

[#5]

Thanks nstefaniuk!

This is what I was looking!

Regards