topic Re: Count ignoring multiple dimensions in QlikView

Count ignoring multiple dimensions

Wed, 25 Nov 2020 16:16:04 GMT

I have a simple table and wish to count how often a customer is found in the table.

Date Reference Customer

I want to count the frequency of the field Customer

It sounds so simple but I cannot get my head around it.

Thanks for help

sunny_talwar — Wed, 04 May 2016 16:42:14 GMT

I am not sure I understand the question. Count(Customer) as an expression with Customer as dimension isn't working?

datagrrl — Wed, 04 May 2016 16:50:45 GMT

Is reference the field with the expression? It should work.

Maybe an example QVW would help.

engishfaque — Wed, 04 May 2016 17:09:29 GMT

Dear PM,

Please check listed below expression,

=Count (Aggr (Count (Customer), Date, Reference))

Kind regards,

Ishfaque Ahmed

Fri, 06 May 2016 10:45:09 GMT

I've attached an extract qvw of the data I am trying to analyse.

Thanks for your help !

sunny_talwar — Fri, 06 May 2016 15:39:48 GMT

May be this?

=Count(TOTAL <[cust-code]>[cust-code])

The above is saying that cust-code K982 is repeating 19 times in this table for your current selections. Is this close to what you wanted?