Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to filter dates greater than 2018-Jan,
Count ({< [ Date]={"> 2018-Jan"}>}[ customers])
is giving me error called "undefined values "
@Qlikuser09 be sure that you use the correct date format
for example in your load script you have :
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:
@Qlikuser09 be sure that you use the correct date format
for example in your load script you have :
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: