topic Igone selection QlickView 8.0 in QlikView

How to ignore two selections using version 8.00.

Wed, 02 Jun 2010 08:30:45 GMT

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 ?

Igone selection QlickView 8.0

Wed, 02 Jun 2010 09:01:53 GMT

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

Igone selection QlickView 8.0

Wed, 02 Jun 2010 09:06:03 GMT

Dear Nigel,

Is there another way to do it in this version ?

Igone selection QlickView 8.0

Wed, 02 Jun 2010 10:01:14 GMT

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,

Igone selection QlickView 8.0

Wed, 02 Jun 2010 10:39:20 GMT

Thanks you

Regards,

Phil

Igone selection QlickView 8.0

johnw — Fri, 04 Jun 2010 19:54:56 GMT

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.

Igone selection QlickView 8.0

Sat, 05 Jun 2010 06:52:54 GMT

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

Thanks