topic Re: Linear chat cannot correctly display measures with the condition in App Development

Linear chat cannot correctly display measures with the condition

ZimaBlue — Wed, 25 May 2022 12:41:29 GMT

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)

Re: Linear chat cannot correctly display measures with the condition

vinieme12 — Wed, 25 May 2022 13:37:28 GMT

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

Re: Linear chat cannot correctly display measures with the condition

ZimaBlue — Fri, 10 Jun 2022 19:48:24 GMT

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