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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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") 😉