topic Re: set analysis in QlikView

set analysis

Mon, 19 Nov 2012 08:20:59 GMT

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

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

Re: set analysis

jagan — Mon, 19 Nov 2012 08:24:42 GMT

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.

Re: set analysis

Mon, 19 Nov 2012 09:11:32 GMT

thanks sir..

Re: set analysis

jagan — Mon, 19 Nov 2012 09:18:33 GMT

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.

Re: set analysis

Mon, 19 Nov 2012 10:19:59 GMT

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

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

Re: set analysis

Anonymous — Mon, 19 Nov 2012 10:33:11 GMT

Hi,

Maybe this manual can help u..

Re: set analysis

jagan — Mon, 19 Nov 2012 10:36:15 GMT

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.