topic Re: How can i pass the input box values to select the expression values? in QlikView

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

sridhar423 — Thu, 18 Jun 2015 10:28:27 GMT

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.

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

Anonymous — Thu, 18 Jun 2015 10:45:38 GMT

Hi, Sridhar

please explain more about your question

regards, Alex

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

Thu, 18 Jun 2015 10:49:34 GMT

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

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

qlikmsg4u — Thu, 18 Jun 2015 10:55:46 GMT

Hi Ruchi,

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

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

qlikmsg4u — Thu, 18 Jun 2015 11:00:09 GMT

Is this kind you are looking for?

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

sridhar423 — Thu, 18 Jun 2015 11:02:32 GMT

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.

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

Thu, 18 Jun 2015 11:57:23 GMT

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.

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

Anonymous — Thu, 18 Jun 2015 12:01:18 GMT

I prepared a solution.

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

Maybe it will be helpful

Regards, Alex

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

Thu, 18 Jun 2015 12:05:50 GMT

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