Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jayaseelan
Creator III
Creator III

Range Split Between two inputs

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,

6 Replies
ogster1974
Partner - Master II
Partner - Master II

This extension should be just what you need.

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

jayaseelan
Creator III
Creator III
Author

Hi Andy weir,

      Thanks for your reply, I already have this extension.

     My problem is how write expression for this scenario?. 

ahaahaaha
Partner - Master
Partner - Master

Hi,

May be like this 

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

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

Regards,

Andrey

Not applicable

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
Creator III
Creator III
Author

Hi everyone,

            Thanks for your valuable replies, got the output.

Anonymous
Not applicable

Hi Jayaseelan,

find the attachment.

Capture.PNG

R/Murali.