ignore all selections except on some columns

[ali_hijazi]

Hello

I want to create an expression in which I want to ignore all selections in all fields except for 4 fields

I created the variable vCondition as follows:

=concat({1<$Field-={'Year','Month','Quarter','Country'}>} '[' & $Field & ']=',','))

then in my expression I wrote:

sum({<$(vCondition)>}Amount)

Now everything is working just fine

however the expression sum({<$(vCondition)>}Amount) has to be put in a variable called vSales

now if I put this variable on a chart and use it in the expression as $(vSales) then I get an error garbage after Month

Please advise on how to make this work just fine

[#2]

This thread may help you: ignore all selections apart from 1 field

[Nicole-Smith]

Can you post a .qvw?  It will be much easier to get help that way.

[#4]

Please upload QVW file its easy to solve.