Count if

[Qliksense_77]

Hi,

I have data like below.

How do I make a straigth table which show number of sales per department that is more than 6$?

Department	Costumer	Date	Amount ($)	Number of sales
north	costumer1	01-01-2019	10	1
south	costumer2	02-01-2019	12	1
west	costumer3	03-01-2019	4	1
east	costumer4	04-01-2019	5	1
north	costumer5	05-01-2019	3	1
north	costumer6	06-01-2019	2	1
south	costumer 2	07-01-2019	2	1
north	costumer3	08-01-2019	7	1

[GaryGiles · Accepted solution]

If you add Department as the dimension in your straight table and add the following expression as your message:

count({$<[Amount ($)]={">=6"}>} [Number of sales])

It will give you the number of sales in each department that has an Amount ($) >= 6.

Is that what you were looking for?