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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how can apply filter on dates

Hello Everyone,

i have a date scenario, where i can find and split dates 

 

Date Of BIRTH:-
26 Sep 1946 to 07 Dec 1946

CIRCA 01 Jan 1955 to 31 Dec 1956
'1959', '
'1960',
'1952', 
'1952', 
'1969 to 1971
'1969 to 1971
'1969 to 1971
'1969 to 1971
'1969 to 1971
CIRCA 1949',
CIRCA 1949', 
CIRCA 1961'
'1961'
'1961'
'1961', 
'1957 to 1959
'1957 to 1959
'1957 to 1959
'1957 to 1959
'1957 to 1959

 

And i want to filter "1957 to 1959" and split  dates in this format

Output:-

Date Of BIRTH:-

 

'1957 to 1959
'1957 to 1959
'1957 to 1959
'1957 to 1959
'1957 to 1959

 

 

 

Labels (2)
1 Reply
TRF
Champion II
Champion II

These are dates, just strings. So you can use a simple tFilterRow or tMap to achieve what you want.