Duplicate Invoices by Dates

[Anonymous]

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

[Digvijay_Singh]

Please share sample data and expected output.

[isingh30]

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]

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

[Anonymous]

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

[Anonymous]

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

Invoice No

Invoice Date

Des

Invoiced Quantity

Unit Sales Price

Gross

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]

Add a measure and enter in formula box

[Anonymous]

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