topic Re: Input Box from selecting Range of values in QlikView

Input Box from selecting Range of values

Mon, 04 Jan 2016 10:59:24 GMT

Hi,

I have a requirement to accept the values from the user between From and To values using input box, Based on that input value, my table should show the aggregated value between that specified Range.

Can Anyone help me with this...

Thanks,

Vasant

Re: Input Box from selecting Range of values

sunny_talwar — Mon, 04 Jan 2016 12:00:50 GMT

Do you have a sample where you are trying to implement? I am not sure what exactly is the problem?

Re: Input Box from selecting Range of values

krishna20 — Mon, 04 Jan 2016 12:05:02 GMT

Hi,

May be this video will helps you,

Selecting Arbitrary Date Ranges - YouTube

Re: Input Box from selecting Range of values

HirisH_V7 — Mon, 04 Jan 2016 12:15:08 GMT

Hi,

Check this,

PFA,

Hope this helps,

-Hirish

Re: Input Box from selecting Range of values

Kushal_Chawda — Mon, 04 Jan 2016 12:16:53 GMT

create the variable vFrom & vTo

I have below set of data

ID	Data	Number
101	100	1
101	200	2
101	300	3
101	400	4
101	500	5
101	600	6

to get the values between the number from 2 to 4 write below expression

=sum({<Number={">=$(=vFrom)<=$(=vTo)"}>}Data)

Re: Input Box from selecting Range of values

sfatoux72 — Mon, 04 Jan 2016 12:18:35 GMT

Hi Vasant,

To select a range of value of a numeric field, you could write directly on the search of the field : >=4 <10

You will have the selection of the following value : 4, 5, 6, 7, 8, 9

If you want to input box and a button:

"From" input box associated with the variable vFrom
"To" input box associated with the variable vTo
"Filter" button with the action "Select in Field" with the search string : >=$(vFrom) <=$(vTo)
or use it on set analysis : sum({$<myDimension={">=$(vFrom) <=$(vTo)"}>} Value)

Re: Input Box from selecting Range of values

HirisH_V7 — Mon, 04 Jan 2016 12:22:52 GMT

Hi,

Check this too using multi-Box,

-Hirish

Re: Input Box from selecting Range of values

Mon, 04 Jan 2016 13:10:04 GMT

Hi All,

thanks for the response.. My requirement details are as follows ----

Assume that I have table shows like this

customer name sum(amount)

cust1 1200

cust2 2100

cust3 3000

cust4 4000

Now if I input the value in InputboxA>=2000 and InputboxB<=3000

then my table should show like this

customer name sum(amount)

cust2 2100

cust3 3000

thanks,

vasant

Re: Input Box from selecting Range of values

sfatoux72 — Mon, 04 Jan 2016 15:08:05 GMT

You could find in attachment a qvw with two solutions:

With selection of Customer with a button button
With set analysis (automatic)

Re: Input Box from selecting Range of values

Kushal_Chawda — Mon, 04 Jan 2016 16:00:15 GMT

Create the straight table

Dimension:

Customer Name

Expression:

=sum({<[customer name]={"=sum(Amount)>=$(vFrom) and sum(Amount)<=$(vTo)"}>}Amount)

Re: Input Box from selecting Range of values

Tue, 05 Jan 2016 06:41:58 GMT

Thanks Kush,

Your logic is working good. But when there is no value in 'From' & 'To' field , the table shows zero values. So I consider the logic given by sfatoux72 using button selection.

Re: Input Box from selecting Range of values

Tue, 05 Jan 2016 06:43:47 GMT

thanks sfatoux72. It worked.

Re: Input Box from selecting Range of values

sfatoux72 — Tue, 05 Jan 2016 10:32:07 GMT

Hi Vasant,

I see your answer to Kush about the fact that set analysis did not work when no value in 'From' & 'To' field.

Given that in my reply there was the solution button and set analysis (which does not work either if the fields are empty).

Here is a new qvw that takes into account the empty fields using default value: 0 for vFrom and 1E9 (1'000'000'000) for VTO.

You will find corrections (in orange) for solutions with button and with set analysis

Expression with Set Analysis:

sum({$<[customer name]={"=(sum(amount)>= $(=alt(vFrom,0))) and (sum(amount)<= $(=alt(vTo,1E9)))"}>}amount)

Actions "Select in Field" in field "[customer name]":

='=(sum(amount)>= $(=Alt(vFrom,0))) and (sum(amount)<= $(=Alt(vTo,1E9)) )'

Re: Input Box from selecting Range of values

marjan_it — Sun, 05 May 2019 05:07:24 GMT

thank you for your good answer. How can I add if in expression. for example my expression is
count(DISTINCT( if(FlowStatusID='19',MessageID)))
would you help me?

Re: Input Box from selecting Range of values

marjan_it — Sun, 05 May 2019 05:35:25 GMT

thank you for your good answer. How can I add if in expression. for example my expression is
count(DISTINCT( if(FlowStatusID='19',MessageID)))
would you help me?