Using Variable's Value as Expression

[Anonymous]

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

[jagan]

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.

[#3]

PFA for solution.

[Anonymous]

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?

[qlikmsg4u]

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

[Anonymous]

so through variable its not possible??