Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
fred_s
Not applicable

Re: Re: Expression count()

Do you mean expressions like this..

5 Replies
preminqlik
Not applicable

Re: Expression count()

hi PFa

fred_s
Not applicable

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

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)

fred_s
Not applicable

Re: Re: Expression count()

Do you mean expressions like this..

Not applicable

Re: Expression count()

Thank you Fred