Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Expression count()

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

NameUsernaneServiceMonthshours
a1patcommunication110:30
a1patcommunication211:11
a1patcommunication109:00
b1julcommunication115:00
b1julcommunication105:45
c2kou1207:30
bolsalcommunication807: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)

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Re: Expression count()

Do you mean expressions like this..

View solution in original post

5 Replies
Highlighted
preminqlik
Valued Contributor II

Re: Expression count()

hi PFa

Highlighted
Partner
Partner

Re: Expression count()

Hi Kouens,

See attachment.

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

tempie.JPG.jpg

Highlighted
Not applicable

Re: Expression count()

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)

Highlighted
Partner
Partner

Re: Re: Expression count()

Do you mean expressions like this..

View solution in original post

Highlighted
Not applicable

Re: Expression count()

Thank you Fred