topic Loop and reduce, but not when is NULL in QlikView https://community.qlik.com/t5/QlikView/Loop-and-reduce-but-not-when-is-NULL/m-p/817275#M1259489 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>is there a way to skip Loop and reduce when the values is Null? For example I Loop and reduce on all Salesperson and all customer connected to that Salesperson. I Send all these pdf, one per customer, to the salesperson, but I dont want a customer that have no sales shows in my pdf, like below.</P><P><IMG alt="2015-03-03_0827.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79677_2015-03-03_0827.png" style="width: 620px; height: 102px;" /></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT stabben23 2026-01-26T18:19:17Z Loop and reduce, but not when is NULL https://community.qlik.com/t5/QlikView/Loop-and-reduce-but-not-when-is-NULL/m-p/817275#M1259489 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>is there a way to skip Loop and reduce when the values is Null? For example I Loop and reduce on all Salesperson and all customer connected to that Salesperson. I Send all these pdf, one per customer, to the salesperson, but I dont want a customer that have no sales shows in my pdf, like below.</P><P><IMG alt="2015-03-03_0827.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79677_2015-03-03_0827.png" style="width: 620px; height: 102px;" /></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Loop-and-reduce-but-not-when-is-NULL/m-p/817275#M1259489 stabben23 2026-01-26T18:19:17Z