topic Re: Help Required in Input Box in QlikView

Help Required in Input Box

rajtechnocraft — Fri, 15 Mar 2013 08:49:39 GMT

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

Re: Help Required in Input Box

Fri, 15 Mar 2013 09:19:36 GMT

Upload the sample file will do the needful

Re: Help Required in Input Box

rajtechnocraft — Fri, 15 Mar 2013 10:00:55 GMT

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

Re: Help Required in Input Box

Fri, 15 Mar 2013 10:13:08 GMT

Hi Raj,

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

Regards,

Nirmal.

Re: Help Required in Input Box

sushil353 — Fri, 15 Mar 2013 10:25:22 GMT

hi use

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

in your listbox

Re: Help Required in Input Box

Fri, 15 Mar 2013 17:54:30 GMT

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

Re: Help Required in Input Box

rajtechnocraft — Mon, 18 Mar 2013 09:31:40 GMT

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

Re: Help Required in Input Box

rajtechnocraft — Mon, 18 Mar 2013 09:31:59 GMT

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

Re: Help Required in Input Box

rajtechnocraft — Mon, 18 Mar 2013 10:18:54 GMT

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

Re: Help Required in Input Box

Tue, 19 Mar 2013 10:11:23 GMT

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