topic Re: Using Variable's Value as Expression in QlikView

Using Variable's Value as Expression

Anonymous — Tue, 08 Sep 2015 06:08:51 GMT

Hello,

I am having a variable VTotalSales as Expression and plotting it with Month as Dim.

Problem is that it is displaying same value with diff diff month...

Am I missing something? What is the solution of it?

Regards,

Balraj Ahlawat

Re: Using Variable's Value as Expression

qlikmsg4u — Tue, 08 Sep 2015 06:11:24 GMT

Try to remove "=" in variable exression

Re: Using Variable's Value as Expression

tresB — Tue, 08 Sep 2015 06:12:33 GMT

How do you define your variable?

Re: Using Variable's Value as Expression

Anonymous — Tue, 08 Sep 2015 06:14:15 GMT

Tried but not working.

Re: Using Variable's Value as Expression

Anonymous — Tue, 08 Sep 2015 06:16:01 GMT

In Variable Overview...

Say VTotalSales=sum({<Header={'Sales'}>} amount)

Re: Using Variable's Value as Expression

tresB — Tue, 08 Sep 2015 06:22:59 GMT

Removing '=' from the definition should work (as already suggested by K N above). Else try to share a sample problem qvw.

Re: Using Variable's Value as Expression

Anonymous — Tue, 08 Sep 2015 06:34:15 GMT

How to share sample app, I am not getting any link of attachment in reply option.

Could anyone suggest how I can attach a sample file??

Re: Using Variable's Value as Expression

qlikmsg4u — Tue, 08 Sep 2015 06:37:03 GMT

Follow these steps

Re: Using Variable's Value as Expression

Anonymous — Tue, 08 Sep 2015 06:38:23 GMT

PFA sample file...

Re: Using Variable's Value as Expression

tresB — Tue, 08 Sep 2015 06:40:22 GMT

PFA

Re: Using Variable's Value as Expression

jagan — Tue, 08 Sep 2015 06:41:46 GMT

Hi,

Remove = in the variable declaration.

Example:

=Sum(Sales) --- Will give same value for all the months

Sum(Sales) --- and now in expression you have to use $(variableName)

Hope this helps you.

Regards,

jagan.

Re: Using Variable's Value as Expression

Tue, 08 Sep 2015 06:44:12 GMT

PFA for solution.

Re: Using Variable's Value as Expression

Anonymous — Tue, 08 Sep 2015 07:03:48 GMT

Tresco,

If now, I need to calculate current year or previous year sales using set analysis and variable..

How can I do it?

=sum({<year={'2012'}>} $(VSales))

Will it work?

Re: Using Variable's Value as Expression

qlikmsg4u — Tue, 08 Sep 2015 07:06:34 GMT

=sum({<year={'2012'}>} sales))

Re: Using Variable's Value as Expression

Anonymous — Tue, 08 Sep 2015 07:10:04 GMT

so through variable its not possible??