topic Re: Expression count() in QlikView

Expression count()

Sat, 07 Dec 2013 09:11:15 GMT

Hello everyone!
I need help, I have a simple table object that displays me

Name	Usernane	Service	Months	hours
a1	pat	communication	1	10:30
a1	pat	communication	2	11:11
a1	pat	communication	1	09:00
b1	jul	communication	1	15:00
b1	jul	communication	1	05:45
c2	kou		12	07:30
bol	sal	communication	8	07:50

My problem is that want create another expression that counts the number of times the name appears.

sql I should have something like:

Select Count(*) from mychart GROUP BY (Name,Username,Months,Service)

preminqlik — Sat, 07 Dec 2013 09:20:44 GMT

hi PFa

fred_s — Sat, 07 Dec 2013 09:50:41 GMT

Hi Kouens,

See attachment.

- Show frequency in Listbox
- count(usernane) in table (Yes, usernane with N in your example)
- As textbox with Set analysis

Sat, 07 Dec 2013 10:41:32 GMT

thank you, I love this expresion, I want to know how to retrieve the selected value without defining default

='no of Pats: ' & count( {<Usernane = {'pat'} >} Usernane)

fred_s — Sat, 07 Dec 2013 10:57:03 GMT

Do you mean expressions like this..

Sat, 07 Dec 2013 11:01:14 GMT

Thank you Fred