topic Re: Count Expression? in QlikView

Count Expression?

Fri, 13 Feb 2015 14:06:23 GMT

I want Count of Customers that contribute 10% of cumulative volume.

Here I have Volume Expression like below

Volume Expression : sum({<AsOfPeriod = {'>$(=date($(VMaxAsOFPeriod)-$(VDaysForTrending))) <=$(=date($(VMaxAsOFPeriod)))'},

same_day={'Y'}>} METRIC_VAL)

Here i want to calculate Count of Customers that contribute 10% of cumulative volume.

can u plz give me idea on this.

PabloOrtiz — Fri, 13 Feb 2015 14:11:18 GMT

Hello, try this

count({<Customer = "=your_expression">} distinct Customer)

count({<Customer={"=sum({<AsOfPeriod = {'>$(=date($(VMaxAsOFPeriod)-$(VDaysForTrending))) <=$(=date($(VMaxAsOFPeriod)))'},

same_day={'Y'}>} METRIC_VAL)"}>} distinct Customer)

Fri, 13 Feb 2015 14:15:37 GMT

Thanks for the reply

But here i want 10%,20%,30% contributed customers only for each expression

for example 10% contributed customer ---- 1 expr

20% contributed customer ---- 2 expr

etc

Anonymous — Fri, 13 Feb 2015 14:29:39 GMT

Hi,

Did you try to use dimension limit in your graph?

You can select option to show only the first 10% for exemple

Fri, 13 Feb 2015 14:32:41 GMT

Bobbyraj,

I want it in Expression not in dimension

Anonymous — Fri, 13 Feb 2015 14:41:25 GMT

Yes but when you filter you dimension it will affect the expression.

In fact when you add option to select 10%, the graph will represent the dimension corresponding to the 10% of your expression

Fri, 13 Feb 2015 14:59:27 GMT

Correct but here i am using a straight table with out any dimension and with only expression what i mentioned above in the question.