Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

ignore all selections except on some columns

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

I can walk on water when it freezes
3 Replies
Not applicable

Re: ignore all selections except on some columns

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

Re: ignore all selections except on some columns

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

Not applicable

Re: ignore all selections except on some columns

Please upload QVW file its easy to solve.