topic strange data error in QlikView https://community.qlik.com/t5/QlikView/strange-data-error/m-p/233697#M85227 <HTML><HEAD></HEAD><BODY><P>thank you Ivan, that's it!!</P></BODY></HTML> Thu, 28 Apr 2011 16:02:48 GMT 2011-04-28T16:02:48Z strange data error https://community.qlik.com/t5/QlikView/strange-data-error/m-p/233695#M85225 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a chart (pivot table) with the following data</P><P>Klant</P><P>Soort</P><P>Bedrag</P><P>However, I would like to make calculations with the amount in 'Bedrag', so I am using expressions to calculate the amount.</P><P>If I use this expression (</P><P>=</P><BR /><BR /> <P>if(SOORT='RAMING', Sum(BEDRAG),0)</P><P>a lot of clients are disappearing. See picture, based on the same data, one with the formula above, one with the 'SOORT' as a dimension.</P><P>What am I doing wrong?<IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-4194_sourceID:4194" /></P><P>p.s. i made some data unreadable for privacy reasons.</P><P></P></BODY></HTML> Thu, 28 Apr 2011 15:50:51 GMT https://community.qlik.com/t5/QlikView/strange-data-error/m-p/233695#M85225 2011-04-28T15:50:51Z strange data error https://community.qlik.com/t5/QlikView/strange-data-error/m-p/233696#M85226 <HTML><HEAD></HEAD><BODY><P>Hi, try this:</P><P>sum({$&lt;SOORT = {'RAMING'}&gt;} BEDRAG)</P><P>Regards</P></BODY></HTML> Thu, 28 Apr 2011 15:54:00 GMT https://community.qlik.com/t5/QlikView/strange-data-error/m-p/233696#M85226 2011-04-28T15:54:00Z strange data error https://community.qlik.com/t5/QlikView/strange-data-error/m-p/233697#M85227 <HTML><HEAD></HEAD><BODY><P>thank you Ivan, that's it!!</P></BODY></HTML> Thu, 28 Apr 2011 16:02:48 GMT https://community.qlik.com/t5/QlikView/strange-data-error/m-p/233697#M85227 2011-04-28T16:02:48Z