Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
change the expression like below
Count(Distinct {<PKL_Status={"<=5"},LIT_Status={">0"},BST_IsInactive -={"-1"}>}InvoiceNumber)
change the expression like below
Count(Distinct {<PKL_Status={"<=5"},LIT_Status={">0"},BST_IsInactive -={"-1"}>}InvoiceNumber)
Thanks Kushal!