Help Required in Input Box

[rajtechnocraft]

Hi Experts ,

I am looking for a solution for which i have attached the screenshot

What i want is to have input box which gives me option of >,< and an Amount  input so that the user can enter amount  based on that input all the pie charts below and the list boxes should get filtered meaning associated

Can any one help me

I am stuck

Would much appreciate for immediate help

Regards

Raj

[#2]

Upload the sample file will do the needful

[rajtechnocraft]

Hi Sushil,

Thanks for the reply.

But this will change only pie charts.

I want the list boxes should also get filtered based on the input value

Namely Premises,Category,Region etc should only display values based on the input box .

How do i achiece this.

Regards

Raj

[#4]

Hi Raj,

PFA, verify the test sheet. Hope this is helpful for you

Regards,

Nirmal.

[sushil353]

hi use

=if([Financial Impact Cost]>=$(lowervalue) and [Financial Impact Cost]<=$(Uppervalue),BUILDING_TYPE)

in your listbox

[#6]

Hello Raj,

As per my understanding, use below expression in your listboxes :

=aggr(only({<Value = {"$(vOperator)$(vAmount)"}>}EffectiveDate),EffectiveDate)

where vOperator will be >,<,>=,<=,= selected from input box and vAmount will be amount entered in input box.

Try using it, otherwise I will send you the dummy qvw I made for testing.

Thanks,

itangad

[rajtechnocraft]

Hi,

Thanks for your reply

can u send me the qvw with dummy data

Will it change the values in other list boxes also.when the user gives the input values.

Thanks in advance

Regards

Raj

[rajtechnocraft]

Hi,

Thanks for your reply

can u send me the qvw with dummy data

Will it change the values in other list boxes also.when the user gives the input values.

Thanks in advance

Regards

Raj

[rajtechnocraft]

Hi Experts:

My scenario has 2 input boxes

One is for range selection such as >

                                                   <

                                                   >=

                                                   <=

2nd  input bos is for Amount Entry  enter amount:

Based on these 2 input boxes my all charts should change,all list boxes such as Category,Business Unit,Region,Premises,Incident ID

Can  anyone please help me.

Regards

Raj

[#10]

Hello Raj,

Sorry for delayed response, was occupied somewhere else.

I have used the same expression, as I mentioned in the list box.

PFA.

Let me know if this was helpful or anything else is required.

thanks,

itsangad