Count function expression

[shamitshah]

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

[Kushal_Chawda · Accepted solution]

change the expression like below

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

[shamitshah]

Thanks Kushal!