Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jayaseelan
Contributor 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
Honored Contributor II

Re: Range Split Between two inputs

This extension should be just what you need.

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

jayaseelan
Contributor III

Re: Range Split Between two inputs

Hi Andy weir,

      Thanks for your reply, I already have this extension.

     My problem is how write expression for this scenario?. 

ahaahaaha
Honored Contributor

Re: Range Split Between two inputs

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

Re: Range Split Between two inputs

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
Contributor III

Re: Range Split Between two inputs

Hi everyone,

            Thanks for your valuable replies, got the output.

murliqlik
Contributor

Re: Range Split Between two inputs

Hi Jayaseelan,

find the attachment.

Capture.PNG

R/Murali.

Community Browser