Ignore values from feilds

[anuradhaa]

Hi i have a field called country,

It has lot of values A,B,C,.. and don't know the exact list of values and it is continually growing.

I have a bar chart shows sales by month,Country

I don't want to display Country 'C' in this graph. But i want to load all data(can't elininate it in the script)

So i have use set analysis, but doesn't work

=sum({<COUNTRY-={"C"}>} SALESCOUNT)

please tell me how to fix this issue

Thanks

[senpradip007]

In Script try like

Load

....

....

From <Table> where Country <> 'C';

[anuradhaa]

I can't ignore this value from the script, i want in other charts

Thank You

[sasikanth]

HI

try some thing like below

=sum({<COUNTRY={'*'}-{'C'}>} SALESCOUNT)

[anuradhaa]

Thanks,

I have tried it too, but there chart doesn't behave according to selections.

Thanks

[PradeepReddy]

Try like this...

=sum({<COUNTRY-={'C'}>} SALESCOUNT)

[anuradhaa]

yes, That's the thing that i have tried.But when i use that it shows red underlines after equal sign.

[sasikanth]

HI

try to upload your sample file,,,,,

[Anonymous]

HI,

Try it

=sum({<COUNTRY != {'C'}>} SALESCOUNT)

[anuradhaa]

Hi,,

This is sample qvw.

Please remove County "C" from the chart