topic Count distinct by two fields in QlikView

Count distinct by two fields

Mon, 08 Jul 2013 22:25:27 GMT

Hi,

I have a particular case. I need to get the number of tickets from a db that contains the detail of these. So, the first solution could be "Select distinct (Nume_docum) from Detalles", the trouble is because we have many locals son in sql I could use "Select distinct Codi_local, Nume_docum from Detalles".

Into qlikview i use this expression: "=count(distinct Nume_docum)" and i get the first case, How i do to make qlikview get the total by this fields?

I just want to add Codi_local into dimension at last resource.

Thanks in advance.

Santiago.

Re: Count distinct by two fields

tresB — Tue, 09 Jul 2013 04:14:55 GMT

May be this:

Count ( Distinct Codi_local & Nume_docum)

Re: Count distinct by two fields

Tue, 09 Jul 2013 04:33:00 GMT

I'm not quite sure I understand what you're asking. But if what you're asking is how to do a distinct count of "Nume_docum" for a specific Codi_local without displaying Codi_local as a dimension, you can probably use set analysis.

E.g.count({<Code_local = {'some value'}>} distinct Nume_docum)

Re: Count distinct by two fields

Tue, 09 Jul 2013 14:55:55 GMT

Thanks for your response.

Regards,

Santiago.

Re: Count distinct by two fields

Tue, 09 Jul 2013 14:58:42 GMT

Thanks for you response, but on your way i get the total for every codi_local, what i needed was a total by 'combination'

Thanks again.

Santiago.