topic Re: Distinct Flag in QlikView https://community.qlik.com/t5/QlikView/Distinct-Flag/m-p/1437036#M431600 <HTML><HEAD></HEAD><BODY><P>I am sorry, the last column is supposed to be customer, not car.</P></BODY></HTML> Mon, 18 Sep 2017 19:59:58 GMT qlikofba 2017-09-18T19:59:58Z Distinct Flag https://community.qlik.com/t5/QlikView/Distinct-Flag/m-p/1437033#M431597 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data below,</P><P></P><P></P><P>region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Customer&nbsp;&nbsp;&nbsp; Color Blue Flag&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 10pt;">Car</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">South&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN style="font-size: 13.3333px;">South&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN style="font-size: 13.3333px;">South&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN style="font-size: 10pt;">South&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I want this chart to be displayed as below</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Color blue&nbsp;&nbsp;&nbsp;&nbsp; Car</SPAN></P><P>South&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P>How can i make expressions doing so? I have count(distinct Car) for the third column but am struggling with the second since the flag is 'Yes' I would like to try to use set analysis if possible.</P><P></P><P>THanks,</P></BODY></HTML> Mon, 18 Sep 2017 19:22:42 GMT https://community.qlik.com/t5/QlikView/Distinct-Flag/m-p/1437033#M431597 qlikofba 2017-09-18T19:22:42Z Re: Distinct Flag https://community.qlik.com/t5/QlikView/Distinct-Flag/m-p/1437034#M431598 <HTML><HEAD></HEAD><BODY><P>Assuming you want the count of only Blue Color Car Count, below expression may help.</P><P></P><P>Count({&lt;[Color Blue Flag] ={"YES"} &gt;} Car)</P></BODY></HTML> Mon, 18 Sep 2017 19:43:14 GMT https://community.qlik.com/t5/QlikView/Distinct-Flag/m-p/1437034#M431598 krishnacbe 2017-09-18T19:43:14Z Re: Distinct Flag https://community.qlik.com/t5/QlikView/Distinct-Flag/m-p/1437035#M431599 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P></P><P>Add a straight table </P><P>Dim: region</P><P></P><P>Expr1: = Sum( Aggr(Count(DISTINCT Car), region, Customer))</P><P>Expr:2 = Count(DISTINCT {&lt; ColorBlue = {'Yes'} &gt;} ColorBlue)</P><P></P><P><SPAN style="text-decoration: line-through;">//Expr2: = Only({&lt; ColorBlue = {'Yes'} &gt;} ColorBlue)</SPAN></P><P></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176973_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 18 Sep 2017 19:47:01 GMT https://community.qlik.com/t5/QlikView/Distinct-Flag/m-p/1437035#M431599 vishsaggi 2017-09-18T19:47:01Z Re: Distinct Flag https://community.qlik.com/t5/QlikView/Distinct-Flag/m-p/1437036#M431600 <HTML><HEAD></HEAD><BODY><P>I am sorry, the last column is supposed to be customer, not car.</P></BODY></HTML> Mon, 18 Sep 2017 19:59:58 GMT https://community.qlik.com/t5/QlikView/Distinct-Flag/m-p/1437036#M431600 qlikofba 2017-09-18T19:59:58Z Re: Distinct Flag https://community.qlik.com/t5/QlikView/Distinct-Flag/m-p/1437037#M431601 <HTML><HEAD></HEAD><BODY><P>Just use like </P><P></P><P>= Count(Distinct Customer)</P></BODY></HTML> Mon, 18 Sep 2017 20:22:43 GMT https://community.qlik.com/t5/QlikView/Distinct-Flag/m-p/1437037#M431601 vishsaggi 2017-09-18T20:22:43Z