Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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

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,