Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to simplify my expression on search string ?

Hi All

Now i use a button for filter Current Asset

On the action, i choose = select in field  :- field name i enter "Reporting Code"

On the search string i enter :-

(50010|50011|50016|50020|50021|50022|50012|50024|50028|50014|50029|50013|50025|50026|50030|50035|50040|50051|50043|50050|50092|50053|50055|50056|50057|50058|50059|50060|50065|50083|50075|50085|50090)

My question is it there any short cut where i can write >=50010 <= 50090 ? ( Since the number is running from 50010 till 50090. )

Paul

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi Paul,

This one seem to work

='>=' & 50001 & '<=' & 50090

Regards,

Sokkorn

View solution in original post

7 Replies
Not applicable

try this

ValueLoop(50010,50090,1)

paulyeo11
Master
Master
Author

Hi Sir

I try but it still not working. See the enclosed file.

er_mohit
Master II
Master II

try with equal sign

=' >=50010 & <= 50090'

but i works for me

click on button after doing it

see the attached file


sushil353
Master II
Master II

Valueloop and valuelist functions are used for calculated dimensions.

they cant be used as search string

paulyeo11
Master
Master
Author

I try your advise , same it does not work.

Sokkorn
Master
Master

Hi Paul,

This one seem to work

='>=' & 50001 & '<=' & 50090

Regards,

Sokkorn

View solution in original post

paulyeo11
Master
Master
Author

wonderful , it work now. many thank.