Filter countries sales quantity in expression

[madhuqliklondon]

Hi all,

I have columns Orderno, Country, SalesQty, SalesAmount,ItemNo_, BrandName.

Now I want use BrandName as dimension and In one expression I would like to get count of all No items belongs to that brand and 2nd expression how many are sold in particular country.

Example. Brand is Givenchy and it sells 100 products this is first expression, and In 2nd expression I would like to see how many of these 100 item sold in UK lets say 40.

example results:

Brand	No.Total Available Item	No. of Items sold in UK
Givenchy	100	40

Thank you in advance.

[tresesco]

Try like:

Exp1: Count( Distinct ItemNo_)

Exp2: Sum({<Country={'UK'}>}SalesAmount)

[madhuqliklondon]

Hi Tresesco,

In Exp 2 ,I want to count how many item sold but not the amount. Is that correct in that expression and If I want to and another country let's say USA can I add it as well?

[raviityou]

you  can use ,

Aggr( Count(ItemNo_),Country,BrandName),

share sample .qvw

[sunny_talwar]

May be try tresesco‌'s 2nd expression like this

Count(Distinct {<Country={'UK'}>} ItemNo_)

[tresesco · Accepted solution]

Yes, like:

Exp2: Count({<Country={'USA'}>} Distinct ItemNo_)

[madhuqliklondon]

Both Sunny's and Tresesco's Exp 2 are working.

Thank you