This function returns the count of an expression over a number of records in business data as defined by a group by clause. If the distinct occurs before the expression, all duplicates will be discarded.
count([distinct ] expression | * )
Load Month, count(Sales) as NumberOfSalesPerMonth from abc.xls group by Month;
Load Month, count(distinct Customer) as CustomerBuyingPerMonth from abc.xls group by Month;
LoadMonth, count(*) as NumberOfRecordsPerMonth from abc.xls group per Month;
Type of Count function:
Please go through below link
Returns the aggregated total count of values from expression or field iterated over the chart dimension(s).
For this function it is allowed to use the distinct qualifier in combination with the total qualifier This combination is not valid for any other aggregation functions.
count(Sales)/count(total Sales) returns sales within the selection
It s part of the Aggregation function. the basic use would be to count how many times something happen in a list.
For example, i am dealing here with hotel packages (forfait) and with the following expression, i would ask Qlikview
Everytime, you have 'Forfait' a in the column Type_Forfait, you count the value in the column Unit
The official definition is : Returns the count of expression over a number of records as defined by a group by clause. If the word distinct occurs before the expression, all duplicates will be disregarded.
Pay attention also to the function called DISTINCT very important for that kind of activity.$
If you need more help, please provide me with some détails.
Attached, the visual use of my expression. The column "NOMBRE" returns the number of package.