topic Re: Problem with Nulls again! in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Nulls-again/m-p/411750#M1157441 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 11 Jan 2013 09:13:08 GMT 2013-01-11T09:13:08Z Problem with Nulls again! https://community.qlik.com/t5/QlikView/Problem-with-Nulls-again/m-p/411748#M1157438 <HTML><HEAD></HEAD><BODY><P>Hello, on the billing database&nbsp; I work with I have a problem reporting on if 2 payments come in on at the same time/day. For example</P><P></P><P>[Customer Number][ Paid amount][Date]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Type]</P><P>1150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; £54&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/04/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P>1150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; £67&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/04/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P></P><P>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.</P><P></P><P>Ive Tried Firstsortedvalue( DISTINCT [Type],-[Date] ) but this doesnt work.</P><P></P><P>Any ideas Please?</P><P></P><P>Paul.</P></BODY></HTML> Thu, 10 Jan 2013 16:52:33 GMT https://community.qlik.com/t5/QlikView/Problem-with-Nulls-again/m-p/411748#M1157438 2013-01-10T16:52:33Z Re: Problem with Nulls again! https://community.qlik.com/t5/QlikView/Problem-with-Nulls-again/m-p/411749#M1157440 <HTML><HEAD></HEAD><BODY><P>Dear Mrpjspencer,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Can you please give me some clarification on your requiremnet,<SPAN style="text-decoration: underline;">how you want to show report</SPAN> and <SPAN style="text-decoration: underline;">Type</SPAN></P><P></P><P></P><P></P><P>Thanks</P><P>SHAIK<SPAN style="text-decoration: underline;"><BR /></SPAN></P></BODY></HTML> Thu, 10 Jan 2013 18:24:52 GMT https://community.qlik.com/t5/QlikView/Problem-with-Nulls-again/m-p/411749#M1157440 Anonymous 2013-01-10T18:24:52Z Re: Problem with Nulls again! https://community.qlik.com/t5/QlikView/Problem-with-Nulls-again/m-p/411750#M1157441 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 11 Jan 2013 09:13:08 GMT https://community.qlik.com/t5/QlikView/Problem-with-Nulls-again/m-p/411750#M1157441 2013-01-11T09:13:08Z