topic Counting Unique values in QlikView https://community.qlik.com/t5/QlikView/Counting-Unique-values/m-p/117009#M753990 <HTML><HEAD></HEAD><BODY><P>Hi Community.</P><P>I have a unique situation in my dashboard which has me stomped:</P><P>I have data flowing in on an aggregated basis which populates one of the tabs i.e. YTD Sales = $XX. On another tab, I have a weekly view of this sales figure i.e. Week of 9/8/18 = $XX. </P><P>The issue is that when no week is selected, the YTD $XX is being doubled and in some cases tripled if that particular item has more than one weeks worth of data.</P><P></P><P>How can I distinguish the aggregate YTD data to show only the unique $XX and disregard other weekly values?</P><P></P><P>My aggregate expression is as follows:</P><P></P><P>=Count({&lt;[Issue Category], [Issue Category]={'UnContained'},Reference_Only={'No'}&gt;}&nbsp; [Issue Category])</P><P></P><P>Any help provided will be greatly appreciated. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT ZoeM 2020-11-25T16:16:04Z Counting Unique values https://community.qlik.com/t5/QlikView/Counting-Unique-values/m-p/117009#M753990 <HTML><HEAD></HEAD><BODY><P>Hi Community.</P><P>I have a unique situation in my dashboard which has me stomped:</P><P>I have data flowing in on an aggregated basis which populates one of the tabs i.e. YTD Sales = $XX. On another tab, I have a weekly view of this sales figure i.e. Week of 9/8/18 = $XX. </P><P>The issue is that when no week is selected, the YTD $XX is being doubled and in some cases tripled if that particular item has more than one weeks worth of data.</P><P></P><P>How can I distinguish the aggregate YTD data to show only the unique $XX and disregard other weekly values?</P><P></P><P>My aggregate expression is as follows:</P><P></P><P>=Count({&lt;[Issue Category], [Issue Category]={'UnContained'},Reference_Only={'No'}&gt;}&nbsp; [Issue Category])</P><P></P><P>Any help provided will be greatly appreciated. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Counting-Unique-values/m-p/117009#M753990 ZoeM 2020-11-25T16:16:04Z