Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Input Box from selecting Range of values

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

1 Solution

Accepted Solutions
sfatoux72
Partner - Specialist
Partner - Specialist

You could find in attachment a qvw with two solutions:

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

View solution in original post

14 Replies
sunny_talwar

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

krishna20
Specialist II
Specialist II

Hi,

May be this video will helps you,

Selecting Arbitrary Date Ranges - YouTube

HirisH_V7
Master
Master

Hi,

Check this,

Slider.PNG

PFA,

Hope this helps,

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
Kushal_Chawda

create the variable vFrom & vTo

I have below set of data

ID Data Number
1011001
1012002
1013003
1014004
1015005
1016006

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

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

Capture.JPG

sfatoux72
Partner - Specialist
Partner - Specialist

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)
HirisH_V7
Master
Master

Hi,

Check this too using multi-Box,

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
Not applicable
Author

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

sfatoux72
Partner - Specialist
Partner - Specialist

You could find in attachment a qvw with two solutions:

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

Create the straight table

Dimension:

Customer Name

Expression:

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