topic Set Analysis problem in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/371312#M138090 <HTML><HEAD></HEAD><BODY><P>Try checking "Suppress Null Values" for the Vendor dimension.</P></BODY></HTML> Mon, 28 May 2012 11:41:21 GMT Jason_Michaelides 2012-05-28T11:41:21Z Set Analysis problem https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/371311#M138089 <HTML><HEAD></HEAD><BODY><P>Hi everybody.</P><P>Totally can't understand whats going on - i have 2 source tables in doc - first is "sales",&nbsp; second - "ware attributes" (vendor, weight etc). Tables connected by ware id. On the sheet i have chart with 2 dimensions - ware_id and vendor&nbsp; and two expressions - sales and total sales. Total sales expression contains "{1} total". Problem is when i add&nbsp; "{1} total" to expression - some wares are duplicated and shown both with vendor and without vendor (vendor is null). If i delete "{1} total" everything is ok - every wares have vendors and aren't duplicated. Looks like "{1} total" make some problems with tables connection. Where is problem?</P><P>Thanx for helping and sorry for poor English)</P></BODY></HTML> Mon, 28 May 2012 11:13:09 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/371311#M138089 2012-05-28T11:13:09Z Set Analysis problem https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/371312#M138090 <HTML><HEAD></HEAD><BODY><P>Try checking "Suppress Null Values" for the Vendor dimension.</P></BODY></HTML> Mon, 28 May 2012 11:41:21 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-problem/m-p/371312#M138090 Jason_Michaelides 2012-05-28T11:41:21Z