Numeric searches

HelloHMC

I want to use the method below to limit the range of number in chart expression, but it can‘t limit the range of number successfully.

This is my test data:

[XXX]:

load

*

inline [

A,B

1,2

2,3

3,4

4,6

5,6

4,6

3,7

];

Then I want to build a line chart, the chart expression is as below:

Dimensions: "A"

Measures: Count({$<A={">=3<= 4)"}>}B)

But the line chart, no matter what is the end value of “A” I have chosen, it will display to 5.

That means the expression didn't refrain the "A" correctly.

I want to confirm if I write the chart expression correctly or not.

BTW, I have written it according to the qlik learning.

ysalvi43

Hello
Please find below working logic, attaching screenshot for reference
Logic: Count({$<A={">=3 <=4"}>} B)

Reason:

There is a ) inside the search string, which breaks the syntax

Screenshot:

If you find useful, Please mark this as Solution

Thanks

Related Topics