topic Re: Show values when preceding value is null or zero in QlikView https://community.qlik.com/t5/QlikView/Show-values-when-preceding-value-is-null-or-zero/m-p/266429#M100122 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>This is my offer, pls to see object attached</P><P>Good luck, Luis</P></BODY></HTML> Sun, 23 Oct 2011 09:44:22 GMT llauses243 2011-10-23T09:44:22Z Show values when preceding value is null or zero https://community.qlik.com/t5/QlikView/Show-values-when-preceding-value-is-null-or-zero/m-p/266427#M100120 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P>I've got a set of data with 3 dims (as per below; period gets values from 1 to 6) and try to create an expresion that would show values when value from preceding period is null or is zero. Any idea how to create it?</P><P></P><P>Input</P><P>-------</P><P>Employee, Period, Amount</P><P>John, 1, 20</P><P>John, 3, 30</P><P>Mary, 1, 50</P><P>Mary, 2, 70</P><P></P><P>Output</P><P>---------</P><P>Employee, Period, Amount</P><P>John, 3, 30</P><P></P><P></P><P>Regards,</P><P>Przemek</P></BODY></HTML> Fri, 21 Oct 2011 15:08:19 GMT https://community.qlik.com/t5/QlikView/Show-values-when-preceding-value-is-null-or-zero/m-p/266427#M100120 2011-10-21T15:08:19Z Show values when preceding value is null or zero https://community.qlik.com/t5/QlikView/Show-values-when-preceding-value-is-null-or-zero/m-p/266428#M100121 <HTML><HEAD></HEAD><BODY><P>Any idea, please?</P></BODY></HTML> Sun, 23 Oct 2011 07:26:58 GMT https://community.qlik.com/t5/QlikView/Show-values-when-preceding-value-is-null-or-zero/m-p/266428#M100121 2011-10-23T07:26:58Z Re: Show values when preceding value is null or zero https://community.qlik.com/t5/QlikView/Show-values-when-preceding-value-is-null-or-zero/m-p/266429#M100122 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>This is my offer, pls to see object attached</P><P>Good luck, Luis</P></BODY></HTML> Sun, 23 Oct 2011 09:44:22 GMT https://community.qlik.com/t5/QlikView/Show-values-when-preceding-value-is-null-or-zero/m-p/266429#M100122 llauses243 2011-10-23T09:44:22Z Re: Show values when preceding value is null or zero https://community.qlik.com/t5/QlikView/Show-values-when-preceding-value-is-null-or-zero/m-p/266430#M100123 <HTML><HEAD></HEAD><BODY><P>Hi Luis, thank you for your offer. It's a kind of way out but, as there as thousands of records, I'd need a chart showing only the values except for blanks + the values. Any idea on that?</P></BODY></HTML> Sun, 23 Oct 2011 13:42:47 GMT https://community.qlik.com/t5/QlikView/Show-values-when-preceding-value-is-null-or-zero/m-p/266430#M100123 2011-10-23T13:42:47Z