topic Re: Need help in Expression (Total) in QlikView

Need help in Expression (Total)

Thu, 08 Aug 2013 09:21:08 GMT

Hi,

The expression which is not working as I am trying to find overall % of each customer, and the expression is as followed and the Tras_No has some duplicate records so when I use TOTAL with Distinct the expression become incorrect, could you please any one suggest workaround for this.

=Count(Distinct(Trs_No))/Count(TOTAL(Distinct(Trans_No)))

Regards

Chriss

Re: Need help in Expression (Total)

Thu, 08 Aug 2013 09:24:43 GMT

try this

=Count(Distinct(Trs_No))/Count(TOTAL Distinct(Trans_No))

Re: Need help in Expression (Total)

Thu, 08 Aug 2013 09:29:02 GMT

also try this

=Count(Distinct Trs_No)/Count(TOTAL Distinct Trans_No)

Re: Need help in Expression (Total)

Anonymous — Thu, 08 Aug 2013 09:31:01 GMT

Total for each customer would need to have something like this:

=Count(Distinct(Trs_No))/Count(TOTAL <Customer> (Distinct(Trans_No)))

Alternatively, I think you can also use the Aggr() function like this:

=Count(Distinct(Trs_No))/Aggr(Count((Distinct(Trans_No))), Customer)

Jonathan