Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shamitshah
Contributor

Count function expression

Hi,

I am having an issue with the following expression in Qlik Sense (basically it is a count of invoices with three conditions):

=Count(Distinct(if({<PKL_Status={'<=5'},LIT_Status={'>0'},BST_IsInactive <> (-1)>}InvoiceNumber))

Should i be using an AGGR function? Any idea what the correct expression should be?

Thanks

Shamit

1 Solution

Accepted Solutions

Re: Count function expression

change the expression like below

Count(Distinct {<PKL_Status={"<=5"},LIT_Status={">0"},BST_IsInactive -={"-1"}>}InvoiceNumber)

2 Replies

Re: Count function expression

change the expression like below

Count(Distinct {<PKL_Status={"<=5"},LIT_Status={">0"},BST_IsInactive -={"-1"}>}InvoiceNumber)

shamitshah
Contributor

Re: Count function expression

Thanks Kushal!

Community Browser