Using variables in expressions

Sat, 18 Jul 2015 07:11:30 GMT

Hi,

Can anybody please help me?

Due to a system upgrade, I need to consolidate sales data from two sources, "Old Sales Data" and "New Sales Data".

Simply loading both as "Sales" in my load script causes problems.

I've created a variable, $(Total Sales), being the sum of "Old Sales Data" plus the sum of "New Sales Data", which works fine.

The following expressions:

Sum (if (InMonth (Date, Today(), 0), [Old Sales Data])) and Sum (if (InMonth (Date, Today(), 0), [New Sales Data]))

also work fine.

I now want to use the same expression using my Total Sales variable, something like Sum (if (InMonth (Date, Today(), 0), $(Total Sales))), but cannot get it to function.

Sum (if (InMonth (Date, Today(), 0), [Old Sales Data])) + Sum (if (InMonth (Date, Today(), 0), [New Sales Data])) is the only way I have so far been able to return the value I require. This seems to be unnecessarily cumbersome. If I can use the variable then changing nearly a hundred expressions in my file can be simply achieved with the expressions editor, rather than a laborious longhand process.

Any help or suggestions on alternative management would be much appreciated.

Thank You.

topic Using variables in expressions in QlikView

Using variables in expressions