COUNT column

[#1]

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!

[Ivan_Bozov]

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

[maxgro]

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

[#4]

thank you!

[#5]

thank you!