Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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
Luminary
Luminary

Re: COUNT column

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

MVP
MVP

Re: COUNT column

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

Re: COUNT column

thank you!

Not applicable

Re: COUNT column

thank you!

Community Browser