topic Re: Get Values "Concat()" between in QlikView

Get Values "Concat()" between

MarcoARaymundo — Mon, 14 Mar 2016 20:11:03 GMT

Hi!

I have a list result of the expression:

Concat(Aggr(Avg({<PRICE={'>0'}, PRICECV={'>0'}>} PRICE), COD, STORE), ';', PRICE)

=>12,25;12,25;12,25;12,98;12,98;12,99;12,99;12,99;13,17;13,98

I need take values between 12,35 and 13,41

Any ideas

Tks

Re: Get Values "Concat()" between

swuehl — Mon, 14 Mar 2016 20:21:47 GMT

Maybe like

Concat(Aggr( If( Avg({<PRICE={'>0'}, PRICECV={'>0'}>} PRICE) >=12.35 AND Avg({<PRICE={'>0'}, PRICECV={'>0'}>} PRICE) <=13.41, Avg({<PRICE={'>0'}, PRICECV={'>0'}>} PRICE) ) , COD, STORE), ';', PRICE)

Re: Get Values "Concat()" between

MarcoARaymundo — Mon, 14 Mar 2016 20:31:21 GMT

Tks, but did not work.

the values min and max, vary by product.