Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis problem

Hi everybody.

Totally can't understand whats going on - i have 2 source tables in doc - first is "sales",  second - "ware attributes" (vendor, weight etc). Tables connected by ware id. On the sheet i have chart with 2 dimensions - ware_id and vendor  and two expressions - sales and total sales. Total sales expression contains "{1} total". Problem is when i add  "{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?

Thanx for helping and sorry for poor English)

1 Reply
Jason_Michaelides
Partner - Master II
Partner - Master II

Try checking "Suppress Null Values" for the Vendor dimension.