topic Condition with variables in QlikView

Condition with variables

Anonymous — Wed, 16 May 2012 17:29:45 GMT

Hi all,

I have variables

How can I add condition B='bbb' to this expression?

([1st Time]-after([1st Time]))/SQRT((($(v2)+after($(v2)))/($(v2)*after($(v2))))*($(v1)*(N-1)+after($(v1))*(after($(v2))-1))/($(v2)+after($(v2))-2))

B='bbb' uses for v1 and v2.

Thanks in advance,

Condition with variables

Anonymous — Wed, 16 May 2012 20:25:12 GMT

Who knows how to add SET ANALYSIS for

SQRT((($(v2)+after($(v2)))

I need B='bbb'

Thanks,

Condition with variables

Anonymous — Thu, 17 May 2012 00:15:48 GMT

Set analysis works in aggregation functions, and SQRT is not one of them. Without trying to understand your logic - may be you can just add the condition to your variables?

v1=Sqr(Stdev({<={'aaa'}, B={'bbb'}>}))

v2=Count({<={'aaa'}, B={'bbb'}>})

Condition with variables

Anonymous — Thu, 17 May 2012 13:37:30 GMT

Hi Michael,

My variable B has 14 different tags(aaa,bbb,ccc,...., fff).

I try to replace B from v1 and v2 to in an expression. Because A is constant for all charts, only B changed in each chart. Other words, I need to add 28 variables, if I add B to your case.

I try to find a trick.

Thanks for reply,