Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Problem with Nulls again!

Dear Mrpjspencer,

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

Thanks

SHAIK

Not applicable

Re: Problem with Nulls again!

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.