Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do you do a "count" based on specific item in a list

In my example attached, I would like to count how many times, I have "Swiss Boat" as a supplier  ? quite simple I know but I am just starting today..

thanks

Ce message a été modifié par : jean-philippe favre

6 Replies
Anonymous
Not applicable
Author

count(if(Supplier='Swiss Boat', Activity))
or

count({<Supplier={'Swiss Boat'}>}  Activity)

MK_QSL
MVP
MVP

SCRIPT....

LOAD

  RowNo() as NO,

  Supplier,

    Activity

FROM ..........

(Assuming that you know how to load an excel file...)

Now Create a text box and enter below in the expression..

=COUNT({<Supplier = {'Swiss Boat'}>}Supplier)

alexandros17
Partner - Champion III
Partner - Champion III

Here there is an example

Not applicable
Author

Thanks great

Not applicable
Author

Thanks to all.

Not applicable
Author

Ok now next level on a COUNT...I need to count the number of 24h card used, but on my list, 1 card could be used several times. in the document attached you can that we have 14 activities but only 9 cards ?

Questions :

How do I extract the number of 24h cards ?

How do I calculate the average use of those cards, in my example, it will be 1.55 (meaning 14 / 9) ?

Thanks