Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor II

Count of Accounts which are invoiced mutiple times

I have Dim_Account  where i get Account number  and Fact_Invoice table where we get invoiced Amount

My requirement is to show a graph   like Revenue vs Monthyear   and Number Accounts Vs MonthYear.

if i include invoice_Amount my Account number count are  not matching and givving huge number.

If i remove Invoice_Amt from query and count on account_nbr i get right number of accounts,

Please suggest me how to handle this as i need both invoice_Amt and Account_Nbr Counts.



1 Reply

Re: Count of Accounts which are invoiced mutiple times

Not sure, but maybe you just need a distinct count?

=Count(DISTINCT account_nbr)

Community Browser