Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT 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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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 )