Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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, '|')