QlikView App Dev

[johnb023]

I am comparing the costs of upkeep for 2 assets.

In the alternate states [Compare 1] and [Compare 2] I select which 2 assets.

I have a chart each associated with the alternate states.

In my expression I have.

sum({[Compare 2] <AA = [Compare 1]::AA , MAT_ItemNum = {"9*"}>} Mat_Cost)

AA is a "transaction" dimension that holds values such as "material", "Labour"...

This expression work fine.

When I replace the "AA" with a variable the expression throws an error from [Compare 1]....

sum({[Compare 2] <$(vWhichFilter) = [Compare 1]::$(vWhichFilter), MAT_ItemNum = {"9*"}>} Mat_Cost)

Can someone help me with the syntax of this or is this approach simply not possible/wrong?