How works Variable overview

[Anonymous]

Hi all,

Who can help me with variable overview?

I have many calculation in one expression. I want to change them by variables, like

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

then use them in expression:

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

Thanks for your help,

[Anonymous]

The main formula which I want to fix in the penultimate row in the table.

Thanks,

If you want to see it in original, let me know. I just changed expression on v1 or v2.

[IAMDV]

I'll look into this tomorrow and I'll update you asap.

Cheers - DV

[Anonymous]

I'll appreciate it.

Have a good weekend

[Anonymous]

Hi Deepak,

Did you have a chance to look into my sample?

Regards,

[IAMDV]

Hi,

Sorry for delay in response.

Let me make sure if I have understood your requirement. You wanted to use below expressions and you wanted change only one field in each chart. For example your default expressions are :

v1=Sqr(Stdev({<[qID_223_Primary Purpose]={'Find product information'},[qID_229_visit frequency]={'First time'}>}[qID_1_Overall how would you rate your experience on the]))

v2=Count({<[qID_223_Primary Purpose]={'Find product information'},[qID_229_visit frequency]={'First time'}>}[qID_1_Overall how would you rate your experience on the])

In the next chart you wanted to change the [qID_229_visit frequency] field to something else like [qID_330_visit frequency] or [qID_331_visit frequency] . But you wanted to have one generic expression which accepts input field names and calculates based input field name, is this right?

And please let me know if you wanted to change only one field (which is highlighted in red) or is it more than one  field?

Cheers,

DV

www.QlikShare.com

[Anonymous]

Hi Deepak,

Yes, in the next chart I want to change [qID_229_visit frequency] to a new variable. Each variable has 3-4 fields.

I tried to use a conditional expression in Chart properties. I don't understand how it works. I wrote a new discussion about it, but no luck.

Thanks again,