Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to use slider instead of hard coded value in text object

Hi All

i am using

=Concat(If(Aggr(rank(Sum(Aggr(Count({<HourFLag={'Violation'}>}[Employee id]),[Employee id],Date))),[Employee id])<=3,[Employee id]),Chr(13))

inside text object

here i want to use slider instead of hard coded value  (here it is <=3) how to get this

Regards

hemesh

1 Solution

Accepted Solutions
crusader_
Partner - Specialist
Partner - Specialist

Hi,

1. Create variable vTo=3 (for example).

2. Create Slider object and choose Mode = Single Value, Data = Variable vTo

3. Set limits and step

4. Change your expression

=Concat(If(Aggr(rank(Sum(Aggr(Count({<HourFLag={'Violation'}>}[Employee id]),[Employee id],Date))),[Employee id])<=$(vTo),[Employee id]),Chr(13))


That's it.


Hope it helps.


Regards,

Andrei

View solution in original post

1 Reply
crusader_
Partner - Specialist
Partner - Specialist

Hi,

1. Create variable vTo=3 (for example).

2. Create Slider object and choose Mode = Single Value, Data = Variable vTo

3. Set limits and step

4. Change your expression

=Concat(If(Aggr(rank(Sum(Aggr(Count({<HourFLag={'Violation'}>}[Employee id]),[Employee id],Date))),[Employee id])<=$(vTo),[Employee id]),Chr(13))


That's it.


Hope it helps.


Regards,

Andrei