topic Help!!! in QlikView

Help!!!

Anonymous — Fri, 25 May 2012 20:22:23 GMT

Hi,

Please help me in an expression.

I have v1 from Variable overview.

I want use it in an expression with set analysis or filter or somehow, but should be selected

({<A={'aaa'}>} $(v1))

Any ideas?

Thanks,

Help!!!

Oleg_Troyansky — Sun, 27 May 2012 04:15:10 GMT

you need to explain your problem a little better...

Help!!!

Anonymous — Mon, 28 May 2012 13:24:15 GMT

Hi Oleg,

I have a complex expression and differents only in selected field.

If(([Personal Use]-Before([Personal Use]))<0 and (1-TDIST(fabs(([Personal Use]-Before([Personal Use]))/SQRT((($(nCoV1L)+Before($(nCoV1L)))/($(nCoV1L)*Before($(nCoV1L))))*($(vCoV1L)*($(nCoV1L)-1)+Before($(vCoV1L))*

(Before($(nCoV1L))-1))/($(nCoV1L)+Before($(nCoV1L))-2))),$(nCoV1L)+Before($(nCoV1L))-2,2))>=.95, RGB(255,0,0))

It's univesal formula, but I should use it for varaiable A, which contaning aaa,bbb,ccc and ddd.

I should use it 4 times. I don't have any ideas how improve it or simplify.

All variables should be selected like SET ANALYSIS

Regards,