How to ignore two selections using version 8.00.

[#1]

I tried to ignore some selections but QV 8.0 does not accept the syntax found on this forum.

Sum( {<SalesOff=,SalesDep,=>} if(YYYY =2010,NetSales))

Can you help me ?

[#2]

Hi

That syntax won't work in QVW 8.0 as the SET ANALYSIS functions did not arrive until v8.50

[#3]

Dear Nigel,

Is there another way to do it in this version ?

[#4]

Not that I know of, although that doesn't mean its impossible, you might want to try adding another thread that is specifically requesting information on how to ignore two selections using version 8.00.

Set Analysis was obviously brought in to do this job but I'm sure somebody had figured out how to achieve it in previous versions, it might be a bit complicated though.

Regards,

[#5]

Thanks you

Regards,

Phil

[johnw]

I can't seem to figure it out. I thought maybe we could use a combination of ALL (to ignore selections) and then some way of detecting the desired selections again. For instance, something like this:

sum(all if(index(getfieldselections(ColumnField),ColumnField),Value))

But it doesn't work, and neither did any variation on the theme that I've tried so far. Now if you only want LITERAL values, and it's OK to ignore all selections, this seems to work:

sum(all if(YYYY=2010,NetSales))

But I can't seem to figure a way to allow some selections but not others.

[#7]

Thank you for your tests. If you know someone who can help me. Give him the link of this discussion.

Thanks