Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

COUNT column

Hello,

I have this table:

LOAD * inline [

Customer|Product|OrderNumber|UnitSales|UnitPrice

Astrida|AA|1|4|16

Astrida|AA|7|10|15

Astrida|BB|4|9|9

Betacab|CC|6|5|10

Betacab|AA|5|2|20

Betacab|BB|1|25| 25

Canutility|AA|3|8|15

Canutility|CC|||19

Divadip|CC|2|4|16

Divadip|DD|3|1|25

] (delimiter is '|');

I just want to count Astrida from the column Customer

I tried with: count(Customer='Astrida') but not work.


Thank you!

4 Replies
Ivan_Bozov
Luminary
Luminary

Hello! Try this: Count({<Customer={'Astrida'}>}Customer)

vizmind.eu
maxgro
MVP
MVP

you need some set analysis as Ivan already suggested

you can find more detail on set analysis here

https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set-analysis...

or here

Set Analysis: syntaxes, examples

Not applicable
Author

thank you!

Not applicable
Author

thank you!