Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvvvvv
Creator
Creator

Filter range

I want user can decided the range of the dimension. Initially, I want to create a range slider but no extension is work for this purpose. So I start to use drop down in variable input. But when I set the formula into Dynamic value of the drop down : concat(valueloop (1,20),'|')

vvvvvvvvvv_0-1594717681436.png

QS recognizes the field as string not number.

How to deal with this? 

 

Labels (3)
1 Solution

Accepted Solutions
vvvvvvvvvv
Creator
Creator
Author

use concat(distinct field_name, '|')

View solution in original post

6 Replies
arulsettu
Master III
Master III

What is the expected output here?

vvvvvvvvvv
Creator
Creator
Author

1
2
3
4
5
6
....
10
11
12

arulsettu
Master III
Master III

Valueloop alone gives the range why using concat here?

 

arulsettu_0-1594719189797.png

 

vvvvvvvvvv
Creator
Creator
Author

 But I need to put it into the variable input...

vvvvvvvvvv
Creator
Creator
Author

Not filter

vvvvvvvvvv
Creator
Creator
Author

use concat(distinct field_name, '|')