topic Set Analysis multiple expressions in QlikView

Set Analysis multiple expressions

paolocamerini — Wed, 15 Nov 2017 10:45:52 GMT

Hello everyone,

I'm trying to get the correct results for an expression that should:

I already tried the following:

Can't solve this, hopefully someone has the solution to this.

Thank you

tresB — Wed, 15 Nov 2017 10:52:58 GMT

Try:

Edit: Corrected -removed '$'

vinieme12 — Wed, 15 Nov 2017 10:53:24 GMT

can you post a sample application and expected output?

paolocamerini — Wed, 15 Nov 2017 10:57:45 GMT

Still not working, thank you though

paolocamerini — Wed, 15 Nov 2017 11:06:20 GMT

LOAD * INLINE [

Data, Cod, X, Amount

14/11/2017, 000001, 3, 1000

14/11/2017, 000002, 6, 5000

14/11/2017, 000003, 7, 8000

14/11/2017, 000004, 2, 750

15/11/2017, 000001, 3, 1200

15/11/2017, 000002, 6, 6000

15/11/2017, 000003, 7, 7500

15/11/2017, 000004, 2, 1000

];

What I'm trying to get is a table with the sum of "Amount" for each Cod whose avg(X) is between 5 and 10

Cod | AvgX | AmountSum

000002 | 6 | 11.000

000003 | 7 | 15.500

tresB — Wed, 15 Nov 2017 11:18:15 GMT

woshua5550 — Wed, 15 Nov 2017 11:25:14 GMT

Try like this

Sum({<Cod={"=Avg(X)>=5 and Avg(X)<=10"}>}Amount)

PFA

paolocamerini — Wed, 15 Nov 2017 11:28:42 GMT

Yes, seems like the expansion sign $ was the culprit. Thank you!