Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
julioarriaga
Creator II
Creator II

Why does separating terms by commas in a set analysis doesn't respect ranges?

This set analysis:

=COUNT({<FechaEval={">=20180802"},FechaEval={"<=20180803"}>}Medicion)"

gives me 3 as a result but it should give me 2 according to my understanding. What I'm getting wrong?

Thanks in advance

P.S. Table I loaded:

T:

LOAD * INLINE [FechaEval,Medicion

20180801,1

20180802,1

20180803,1

20180804,1

20180805,1];

1 Solution

Accepted Solutions
petter
MVP
MVP

You can't repeat the same field - it will only make the last one go into effect. For your specific case you should write:

=Count( {<FechaEval={">=20180802<=20180303"}>} Medicion )

View solution in original post

1 Reply
petter
MVP
MVP

You can't repeat the same field - it will only make the last one go into effect. For your specific case you should write:

=Count( {<FechaEval={">=20180802<=20180303"}>} Medicion )

View solution in original post