Qlik Community

Qlik Sense App Development

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

New Contributor III

how to show Invoice count

I am working on a sales table which has monthly summary till 2016 and have detail transactions for 2017 and 2018.

For the summary table I have  a column 'Invoice Count' which is the total number of sales invoices made during the month whereas the detail transaction have Sales Invoice No so her we put a count function to count the total.

How can I show the count of Sales Invoices in one single column? till 2016 it should show sum(Invoice Count) and after that it should show count(Invoice No).

2 Replies

Re: how to show Invoice count

If one will be null when other have value, you can try this

Count(Alt([Invoice Count], [Invoice No]))

Re: how to show Invoice count

Or just a simple if statement

If(Year = 2016, Count([Invoice Count]), Count([Invoice No]))

Community Browser