set analysis

[#1]

=Count({<Year={'$(vMaxYear)'},Date={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>}DocumentNumber)

what's happening when "Month=,Day=,MonthYear=" in expression..

[jagan · Accepted solution]

Hi,

If you Month=,Day=,MonthYear= in your expression it excludes the selection for Month, Day and MonthYear dimension values. Even selecting this dimension values doesn't have any change in calculation.

Check Set Analysis section in QV help file.

Regards,

Jagan.

[#3]

thanks sir..

[jagan]

Hi,

Please close this discussion by clicking "Correct Answer" button to my post, it helps others in finding the Answer for this question.

Regards,

Jagan.

[#5]

sum( {$<Customer = P({1<Product={‘Shoe’}>} Customer)>} Sales )

can I know what does this "P" element function is doing??

[Anonymous]

Hi,

Maybe this manual can help u..

[jagan]

Hi,

This expression gives you  the sales for current selection of the Customers who bought Product Shoe.

=sum( {$<Customer = P({1<Product={‘Shoe’}>} Customer)>} Sales)

Suppose if there are 5 customers and only 3 Customers bought shoes, then this expression considers only this 3 customers.

Regards,

Jagan.