Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stekol61
Contributor

Count if expression

Hi!

I have data in a table where I want to count nr. of Tickets where Source = 'Event' and present the result i a simple barchart.

I don't want to filter the data in the load script .

How can I create such an expression in Sense?

1 Solution

Accepted Solutions
martinpohl
Valued Contributor II

Re: Count if expression

Hi Stefan,

your expression is count({<source={Event}>} distinct Ticket)

maybe start_date is the Dimension of your bar chart.

Regards

2 Replies
shraddha_g
Honored Contributor III

Re: Count if expression

Count(Distinct {<Source={'Event'}>}Ticket)

martinpohl
Valued Contributor II

Re: Count if expression

Hi Stefan,

your expression is count({<source={Event}>} distinct Ticket)

maybe start_date is the Dimension of your bar chart.

Regards