Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Please share sample data and expected output.

isingh30
Specialist
Specialist

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
Specialist II
Specialist II

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

Anonymous
Not applicable
Author

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
Not applicable
Author

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
Specialist II
Specialist II

Add a measure and enter in formula box

Anonymous
Not applicable
Author

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