Range Split Between two inputs

[jayaseelan]

Hi Experts,

     I need to do the following task, Please give me some ideas,

     I have two inputbox   Box1 and Box2  , I have a age Column as Dimension.

     For  box1 i will gives 5  and box2  10.

   my output is should display the people those who are have age as 5 to 10. What ever the input, my output should depends on it.

I have attached the sample data.

Thanks,

[ogster1974]

This extension should be just what you need.

http://branch.qlik.com/#!/project/58deb0f7aab50ac4c3ddb682

[jayaseelan]

Hi Andy weir,

      Thanks for your reply, I already have this extension.

     My problem is how write expression for this scenario?. 

[ahaahaaha]

Hi,

May be like this 

Sum ({<Age={">=5 <=10"}>}Age)

Instead of "5" and "10" you can use links to your inputboxs.

Regards,

Andrey

[#5]

hi

i have solved this by concat function

U have to make varibales for both input boxes and also define them and then create two other variables value1 and value2 to store the values of input boxes

Concat({<Age={'>=$(value1)<=$(value2)'} >} distinct Name ,',')

I hope this will help u

regards

Harshika

[jayaseelan]

Hi everyone,

            Thanks for your valuable replies, got the output.

[Anonymous]

Hi Jayaseelan,

find the attachment.

R/Murali.