Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help!!!

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,

2 Replies
Anonymous
Not applicable
Author

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,