How can i pass the input box values to select the expression values?

[sridhar423]

Hi All,

I have a Straight Table Country is the Dimension and Sales% is Expression.

I Have a Input Box,

1)if i put 100% in Input box my straight table should show only countries which are having 100%

2)If i put other values like(50%) it should display the countries which are having Sales% less than 50%.

Please any one help me out from this.

Country	Sales%
A	100%
B	20%
C	30%
D	40%
E	100%
F	33%
G	69%
H	100%

Thanks in advance,

Sridhar.

[Anonymous]

Hi, Sridhar

please explain more about your question

regards, Alex

[#3]

Hi Anekc,

I new to Qv.

Kindly help me resolve the following query using the SCD solution. It would be a great help to me

Well, I have the following Inline table

LOAD * INLINE

[

    Product, ProdName, Price, Updated

    123, Watch, 150$, 1/1/2015

    134, Fruit, 30$, 1/1/2015

    145, Ring, 3000$, 3/1/2015

    123, Watch, 125$, 5/1/2015

    123, Watch, 119$, 5/5/2015

    134, Fruit , 50$, 5/5/2015

    145, Ring, 2500$, 5/12/2015

    234, Pen, 12$, 5/17/2015

    312, Jeans, 50$, 6/9/2015

];

Using the above input table, I need to get the below reults

Product	ProdName	Price	Updated	From	To Date
123	Watch	150$	1/1/2015	1/1/2015	4/30/2015
123	Watch	125$	5/1/2015	5/1/2015	5/42015
123	Watch	119$	5/5/2015	5/5/2015	6/18/2015

Help me implementing the same.

Thanks in advance

[qlikmsg4u]

Hi Ruchi,

I suggest you to open new thread, so that it will reach more people and will get answers

[qlikmsg4u]

Is this kind you are looking for?

[sridhar423]

Hi Alex,

I want to filter the sales% values based on input box values..

But in that two conditions are there

1)if i put 100% in Input box my straight table should show only countries which are having 100%

2)If i put other values like(50%) it should display the countries which are having Sales% less than 50%.

First output should be                                                

Country	Sales%
A	100%
E	100%
H	100%

second output should be 

Country	Sales%
B	20%
C	30%
D	40%
F	33%
G	69%
Thanks, Sridhar.

[#7]

Hi,

First Create one varibale and assign it to input box.i have created vVari.

Then wright formula in expression:

if(Amount<$(vVari),Amount,0)

So every time,you enter value in input  box,table will show values lesser then entered value.

[Anonymous]

I prepared a solution.

You should input value in the Inputbox and then click on button 'Select'

Maybe it will be helpful

Regards, Alex

[#9]

Hey,

Check the attached app, you can use slider or input box for this. Create one variable and assign value to that variable according to user selection. PFA