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

Problem with Nulls again!

Hello, on the billing database  I work with I have a problem reporting on if 2 payments come in on at the same time/day. For example

[Customer Number][ Paid amount][Date]               [Type]

1150                        £54               01/04/2012          -

1150                        £67               01/04/2013          -

On the Database each line item does have a type value but because all of the data is the same in the report, it chooses to make it a null when this isnt right.

Ive Tried Firstsortedvalue( DISTINCT [Type],-[Date] ) but this doesnt work.

Any ideas Please?

Paul.

2 Replies
Anonymous
Not applicable
Author

Dear Mrpjspencer,

      Can you please give me some clarification on your requiremnet,how you want to show report and Type

Thanks

SHAIK

Not applicable
Author

I don't it to show Null, I want it to show the actual field name in both even though the data prior to it is identical apart from the cash value.