Linear chat cannot correctly display measures with the condition

[ZimaBlue]

Hello

I am trying to build a line chart with multiple measures by condition. However, I know for sure that the values are incorrect now. In total, the number of all users (sum all measures on chart) should be 3400 customers for May 2022, on a linear graph this amount = 4000+

Measures:

1. count( {<user_id= {"=sum(order_cost)>=50000"}>} distinct user_id)

2. count({<user_id= {"=sum(order_cost)>=20000"}, user_id= {"=sum(order_cost)<50000"}>} distinct user_id)

3. count({<user_id= {"=sum(order_cost)>=10000"}, user_id= {"=sum(order_cost_)<20000"}>} distinct user_id)

dimension: monthname(order_date)

[vinieme12 · Accepted solution]

as below

2. count({<user_id= {"=sum(order_cost)>=20000 and sum(order_cost)<50000"}>} distinct user_id)

3. count({<user_id= {"=sum(order_cost)>=10000 and sum(order_cost_)<20000"}>} distinct user_id)

refer this article

https://community.qlik.com/t5/Qlik-Design-Blog/The-Expression-Search/ba-p/1463907

[ZimaBlue]

sorry for the long answer, was on vacation. it works perfectly, thanks a lot!