topic What is the difference between an expression having '= ' and not having '=' in QlikView

What is the difference between an expression having '= ' and not having '='

kkkumar82 — Thu, 28 May 2015 09:40:32 GMT

Hi all,

can any body explain with an example the difference between sum(Sales) and = sum(Sales) as expressions in charts.

Thanks

Kiran Kumar

Re: What is the difference between an expression having '= ' and not having '='

alexandros17 — Thu, 28 May 2015 09:45:39 GMT

Nothing ... there is no difference

Re: What is the difference between an expression having '= ' and not having '='

rubenmarin — Thu, 28 May 2015 09:45:55 GMT

Hi Kiran, so far I know in chart expressions there is no difference. In other objects like text boxes it's a must-do if you want to calculate something. It also can change the behaviour of a variable.

In big terms, when an expression starts with '=' the expression returns the calculated result, when you don't have that preceding '=' it returns the string. As charts expressions is used to calculate the result, there is no difference using the starting '='.

Re: What is the difference between an expression having '= ' and not having '='

buzzy996 — Thu, 28 May 2015 09:49:46 GMT

nothing much,but his link will helps to understand better,

The Magic of Variables

Re: What is the difference between an expression having '= ' and not having '='

marcus_sommer — Thu, 28 May 2015 11:24:37 GMT

Like always the explanation comes from hic.

The Little Equals Sign

- Marcus

Re: What is the difference between an expression having '= ' and not having '='

Thu, 28 May 2015 11:34:53 GMT

Hi Kiran,

This may help you..

Thanks

Harsha Nandan

Re: What is the difference between an expression having '= ' and not having '='

kkkumar82 — Thu, 28 May 2015 12:15:08 GMT

Thanks Harsha , can u create a sample qvw for this , if possible.

Regards

Kiran Kumar

Re: What is the difference between an expression having '= ' and not having '='

kkkumar82 — Thu, 28 May 2015 12:15:41 GMT

Thank you all for ur valuable suggestions.

Re: What is the difference between an expression having '= ' and not having '='

buzzy996 — Thu, 28 May 2015 12:26:26 GMT

the best example already shared by Marcus Sommer,pls go though tht.

Re: What is the difference between an expression having '= ' and not having '='

Thu, 28 May 2015 12:35:34 GMT

Hi Kiran,

In First Chart: Year as Dimension and Sum(Sales) as Expression

Create a Variable vSales and assign the value as =Sum(Sales) in Variable Overview Window

then Second Chart:Year as Dimension and $(vSales) as Expression

Re: What is the difference between an expression having '= ' and not having '='

kkkumar82 — Thu, 28 May 2015 12:51:40 GMT

Thanks Harsha this is the sample I have created for the clarification.

Re: What is the difference between an expression having '= ' and not having '='

Thu, 28 May 2015 12:55:18 GMT

You are welcome