Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

anirban_musib94
New Contributor

Duplicate Invoices by Dates

Hi,

I am new to Qlik and trying to create dashboards.

I have a table with the sales transaction. Mainly I want to look at all transactions that have same invoice number for multiple Invoice dates. And either displays them in a different table or visualize. I would be indebted if anyone can help me out with the same.

Many Thanks,

Anirban

7 Replies
Digvijay_Singh
Honored Contributor III

Re: Duplicate Invoices by Dates

Please share sample data and expected output.

isingh30
Contributor III

Re: Duplicate Invoices by Dates

There's a sample 'Data Visualization' application in the tool. Please check that. It's a walk through of different charts & table types.

Thank you!

dwforest
Valued Contributor

Re: Duplicate Invoices by Dates

if you had a table with Invoice Id, Invoice date, add a measure = Only({$<[InvoiceID]={"=Count({<[Date]=>} InvoiceID)>1"}>} [InvoiceID])

anirban_musib94
New Contributor

Re: Duplicate Invoices by Dates

Hi David , thank you for the Input !. I know its silly of me to ask, but where would I put the above expression to see the table with the above condition ?

Many Thanks,

Anirban

anirban_musib94
New Contributor

Re: Duplicate Invoices by Dates

Hi Digvijay, I have a table on the dashboard which contains the following fields :

Invoice NoInvoice DateDesInvoiced QuantityUnit Sales PriceGross

Now, I would like to display the same table in another dashboard, but with only those invoice numbers that have multiple invoice dates as well.

Many Thanks,

Anirban

dwforest
Valued Contributor

Re: Duplicate Invoices by Dates

Add a measure and enter in formula box

anirban_musib94
New Contributor

Re: Duplicate Invoices by Dates

Hi David,

The formula seems to be working. But I want to find out all the Invoice No that have multiple unique dates. Like a pharma, medicine Invoice can have n no of the same invoice no for the date 1st Feb. But having the same invoice no on 2nd Feb would be fraudulent. I would like to pull those invoice nos that have multiple unique invoice dates.

Many many thanks,

Anirban

Community Browser