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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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.