topic Re: How works Variable overview in QlikView

How works Variable overview

Anonymous — Wed, 16 May 2012 14:28:56 GMT

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,

Re: How works Variable overview

IAMDV — Wed, 16 May 2012 14:31:11 GMT

You can use the dollar sign expansion. you need something like this...

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

Cheers - DV

www.QlikShare.com

How works Variable overview

Anonymous — Wed, 16 May 2012 14:37:53 GMT

Thanks!!! It works!!!!

So when I used expression which I need to calculate, I should use $.

Thanks a lot.

Re: How works Variable overview

IAMDV — Wed, 16 May 2012 14:42:09 GMT

Great. Yes, I follow a standard practice of storing my expressions in the variables. This way we can use the variables as Abstract layer and it also helps to manage the expressions in centralised environment. I'm attaching a pdf document for your reference. Please check the Dollar Sign Expansion page in the pdf file.

I hope this helps!

Cheers - DV

www.QlikShare.com

How works Variable overview

Anonymous — Wed, 16 May 2012 14:47:34 GMT

Thank for the pdf document.

How to simplify the expression:

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

I have many variables like this, but changed only variable

Regards,

How works Variable overview

Anonymous — Wed, 16 May 2012 15:42:01 GMT

I have variables

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

v2=Count({<={'aaa'}>})

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,

Re: How works Variable overview

IAMDV — Wed, 16 May 2012 15:47:21 GMT

I think you need something like UDF (User Defined Functions). Please read this post and you will learn how to dynamically change your fields while keeping the same calculation methodology in the Variables.

Cheers,

How works Variable overview

Anonymous — Wed, 16 May 2012 16:08:37 GMT

I read the post. It's complicated for me.

I have different 10 tables.

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

v2=Count({<={'aaa'}>})

I remove variable B from v1 and v2. In each of them changed variable B. Variable B is different in each table.

I confused you?

Cheers,

Re: How works Variable overview

IAMDV — Thu, 17 May 2012 10:15:48 GMT

Hi,

Please can you post the sample QVW file? And also give me the list of values which will fit in field B? I'll build a UDF expression.

Regards,

www.QlikShare.com

Re: How works Variable overview

Anonymous — Thu, 17 May 2012 14:20:02 GMT

Thanks for reply,

Please find attached file.

Thanks again,

Re: How works Variable overview

Anonymous — Thu, 17 May 2012 14:43:45 GMT

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.

Re: How works Variable overview

IAMDV — Thu, 17 May 2012 22:25:43 GMT

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

Cheers - DV

Re: How works Variable overview

Anonymous — Fri, 18 May 2012 13:31:16 GMT

I'll appreciate it.

Have a good weekend

Re: How works Variable overview

Anonymous — Wed, 23 May 2012 20:21:59 GMT

Hi Deepak,

Did you have a chance to look into my sample?

Regards,

Re: How works Variable overview

IAMDV — Fri, 25 May 2012 09:03:50 GMT

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,

www.QlikShare.com

Re: How works Variable overview

Anonymous — Fri, 25 May 2012 13:31:27 GMT

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,