topic Re: replace any functions within the expressions with variables? in QlikView

replace any functions within the expressions with variables?

manozpph — Mon, 08 Sep 2014 23:36:49 GMT

Hi Guys,

Here in the Straight Table I have 3 expressions: 1.LineSalesAmount for (3 years) 2.Total Sales 3.Product Sales.

In Straight table,I need to replace any functions within the above 3 expressions with variables to

improve user understanding.

Can Somebody help me how i can replace functions.......?

Thanks in Advance

Re: replace any functions within the expressions with variables?

JonnyPoole — Tue, 09 Sep 2014 00:09:07 GMT

Not sure exactly what you are asking but a couple of pointers:

If you expression is sum(Sales) , then when you create a variable to replace the expression , give it a definition of: sum(Sales) . Do not include a preceding = sign . :This will ensure your expression is evaluated within the context of the chart and not outside the chart. Let say you created the following variable:

variable name: vSales

variable definition: sum(Sales)

Back in the expression definition in the chart your new expression will be:

$(vSales)

Thats all..

Re: replace any functions within the expressions with variables?

danieloberbilli — Tue, 09 Sep 2014 00:10:49 GMT

Go in Settings > Expression Overview (or press Ctrl+Alt+E) and use Find/Replace.

But be careful with this and use a test copy - you might replace expressions you would like to keep.

edited: sorry - didnt see that you were asking for variables...

Kind Regards

Daniel

Re: replace any functions within the expressions with variables?

manozpph — Tue, 09 Sep 2014 14:38:40 GMT

Thank you for your helpful information.

Can you please explain me how can i write new expression using replace function here.

Regards,