Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates

Qlik Replicate filter on a range value

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
KellyHobson
Former Employee
Former Employee

Qlik Replicate filter on a range value

Last Update:

Mar 4, 2024 6:48:29 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jun 13, 2022 1:41:18 PM

It is possible to filter records based on range values set in the 'Filter' Window. This article is an example of setting this up as opposed to setting a Record Level or a Full Load Pass thru filter. We are filtering user_id values 25 and less.

Source table:

1.png

Within Task Designer -> Table Settings -> Filter

2.png

By clicking on the edit button:

3.png

If you export your task to see how it looks in .json format:

4.png

Target data after running the task:

5.png

Environment

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

 

Other article on filtering for reference: 

Filter for last 90 days of data in Qlik Replicate

Labels (2)
Comments
qlikity_qlak
Contributor II
Contributor II

What is the syntax (i.e. what does it look like in the Qlik Replicate UI) when filtering on a string or character value?  Are single quotes, double quotes, etc. required? 

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @qlikity_qlak 

Does this documentation answer your question or are you looking for different information? Transformations and Filters 

All the best,
Sonja 

Version history
Last update:
‎2024-03-04 06:48 AM
Updated by: