topic exclude 3 dimensions in an expression in QlikView

exclude 3 dimensions in an expression

Thu, 19 May 2011 12:36:31 GMT

Hello evryone,

I would like to do a count for an ID and I want to exclude 3 dimensions in my expression, how to do it?

=count({<dimension1 = , dimension2 => ID_field} ==> it work well. But how to add my third dimension in this expression?

If that is not possible, how to exclude 3 dimensions in an expression?

Thank you for your help...

erichshiino — Thu, 19 May 2011 12:47:51 GMT

Hi,

You can exclude as many expressions as you want. The expression is more like this:

count({<dimension1 = , dimension2 = , dimension3 = >} ID_field )

Regards,

Erich

Thu, 19 May 2011 12:55:56 GMT

Thank you Erich, I tried but it doesn't work...

Apparently, it takes at most only 2 dimensions.

Mouhsine

Fri, 20 May 2011 12:52:13 GMT

Hi Erich,

You're right. But it must respect uppercase lowercase Even if QV puts an error highlighted in red.

Thanks Erich...

See you.

Mouhsine