Use of * in set analysis

[#1]

Hi all,

Small question concerning the option to use " * " in an expression.

My expression is the following:

=sum({$<%OrderSoort_Key={$(='810,830')}, Month=>}Sales)

Basically I have a dimension: OrderSoort_Key with values 800 up to 890. I only want to count the values 810 and 830.

AND

I have another dimension named A_Type with text values: BIG, BIG20, BIG30, SMALL

I only want to count BIG, BIG20 and BIG30, so basically everthing starting with BIG.

I thought I could use the expression:

=sum({$<%OrderSoort_Key={$(='810,830')}, A_Type={$(='BIG*'), Month=>}Sales)

But unfortunately it is not working.. It is important for me to tell QV I only want the values starting with "BIG" and I cannot make a limitative list of values to take into consideration, since it is a much longer list than just the 4 is wrote down.

Can anyone help me out?

Cheers!

Zipke

[Gysbert_Wassenaar]

Try:

=sum({$<%OrderSoort_Key={810,830}, A_Type={'BIG*'}, Month=>}Sales)

[johnca · Accepted solution]

Try this;

=sum({$<%OrderSoort_Key={'810','830'}, A_Type={'BIG*'} Month=>}Sales)

( a couple of single quotes around the 810 and 830 were missing )

[#4]

It does not work anymore with your solution, I get a dash..