2 Replies Latest reply: Jun 3, 2016 3:28 AM by Shamit Shah RSS

    Count function expression

    Shamit Shah

      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