topic Re: Filter countries sales quantity in expression in QlikView

Filter countries sales quantity in expression

madhuqliklondon — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Filter countries sales quantity in expression

tresB — Tue, 24 Jul 2018 11:10:11 GMT

Try like:

Exp1: Count( Distinct ItemNo_)

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

Re: Filter countries sales quantity in expression

madhuqliklondon — Tue, 24 Jul 2018 11:17:38 GMT

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?

Re: Filter countries sales quantity in expression

raviityou — Tue, 24 Jul 2018 11:24:10 GMT

you can use ,

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

share sample .qvw

Re: Filter countries sales quantity in expression

sunny_talwar — Tue, 24 Jul 2018 11:26:00 GMT

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

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

Re: Filter countries sales quantity in expression

tresB — Tue, 24 Jul 2018 11:27:45 GMT

Yes, like:

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

Re: Filter countries sales quantity in expression

madhuqliklondon — Tue, 24 Jul 2018 14:37:47 GMT

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

Thank you