Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

Filter date > 2018-Jan

I want to filter dates greater than 2018-Jan, 

Count ({< [ Date]={"> 2018-Jan"}>}[ customers])

is giving me error called "undefined values "

1 Solution

Accepted Solutions
Taoufiq_Zarra

@Qlikuser09  be sure that you use the correct date format

for example in your load script you have :

Taoufiq_Zarra_0-1642018402520.png

in this case for this example:

Data:

load * inline [
Date,customers
2018-Jan,1
2018-Feb,2
2018-Mar,3
2018-Apr,4
];

with this expession:

=Count({<Date={">$(=Date('2018-Jan'))"}>} customers)

I have this ouput:

Capture.PNG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

1 Reply
Taoufiq_Zarra

@Qlikuser09  be sure that you use the correct date format

for example in your load script you have :

Taoufiq_Zarra_0-1642018402520.png

in this case for this example:

Data:

load * inline [
Date,customers
2018-Jan,1
2018-Feb,2
2018-Mar,3
2018-Apr,4
];

with this expession:

=Count({<Date={">$(=Date('2018-Jan'))"}>} customers)

I have this ouput:

Capture.PNG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉