topic Re: Count Distinct with condition in Text Object? in QlikView https://community.qlik.com/t5/QlikView/Count-Distinct-with-condition-in-Text-Object/m-p/1173435#M462757 <HTML><HEAD></HEAD><BODY><P>Thanks a lot. The round brackets after "Distinct" are not necessary.</P></BODY></HTML> Thu, 25 Aug 2016 14:50:15 GMT 2016-08-25T14:50:15Z Count Distinct with condition in Text Object? https://community.qlik.com/t5/QlikView/Count-Distinct-with-condition-in-Text-Object/m-p/1173431#M462753 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I am still quite new to QlikView and could need some help.</P><P></P><P>I would like to track certain changes made in SAP with QlikView.</P><P>The overall tracking is not a problem: I simply use a text object and =Count(Distinct (Änderungsbelegnr)). By counting the individual IDs that are created when a change is made, I now know how many changes were made in total.</P><P></P><P>Now, I would like to distinguish between changes concerning general data and bank data.The Information needed is stored in a different field ("SAP Tabelle"). See screenshot below.</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135556_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/135560_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P>In the second screenshot I marked two of the required values to display changes made in bank details. </P><P>I already thought of an if-statements, maybe in combination with a match-Statement, but I cannot make it work.</P><P></P><P>So what I need in the end is a table box that looks like the following (but displays the corresponding values):</P><P><IMG class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/135561_pastedImage_3.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>The remaining values in the field "SAP Tabelle" will be needed to create the general data figure.</P><P></P><P>I hope I explained my problem well enough. Any suggestions are very welcome and appreciated.</P><P>Thank you in advance.</P><P></P><P>Regards,</P><P>Daniela</P></BODY></HTML> Thu, 25 Aug 2016 13:11:20 GMT https://community.qlik.com/t5/QlikView/Count-Distinct-with-condition-in-Text-Object/m-p/1173431#M462753 2016-08-25T13:11:20Z Re: Count Distinct with condition in Text Object? https://community.qlik.com/t5/QlikView/Count-Distinct-with-condition-in-Text-Object/m-p/1173432#M462754 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Is it like this ?</P><P></P><P>assuming&nbsp; "SAP Tabelle" is a field...</P><P></P><P></P><P>count (Distinct { &lt;[SAP Tabelle]={"LFBK","LFB1"}&nbsp; &gt; }&nbsp; Änderungsbelegnr )</P><P></P><P></P><P></P><P></P><P><STRONG>sorry , if i misunderstood ..your requirement...</STRONG>.</P></BODY></HTML> Thu, 25 Aug 2016 13:56:53 GMT https://community.qlik.com/t5/QlikView/Count-Distinct-with-condition-in-Text-Object/m-p/1173432#M462754 Anonymous 2016-08-25T13:56:53Z Re: Count Distinct with condition in Text Object? https://community.qlik.com/t5/QlikView/Count-Distinct-with-condition-in-Text-Object/m-p/1173433#M462755 <HTML><HEAD></HEAD><BODY><P>try like this</P><P></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Count(Distinct ({&lt;[<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SAP Tabelle</SPAN>]={'LFB1','LFBK'}&gt;}Änderungsbelegnr))</SPAN></P></BODY></HTML> Thu, 25 Aug 2016 14:01:39 GMT https://community.qlik.com/t5/QlikView/Count-Distinct-with-condition-in-Text-Object/m-p/1173433#M462755 avinashelite 2016-08-25T14:01:39Z Re: Count Distinct with condition in Text Object? https://community.qlik.com/t5/QlikView/Count-Distinct-with-condition-in-Text-Object/m-p/1173434#M462756 <HTML><HEAD></HEAD><BODY><P>This works perfectly. Thank you so much!</P><P>And sorry for the confusion. I know it is a bit weird to name a field "Tabelle" <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P></P><P>One additional question that just came to my mind. If I don't want to have the distinct count but the regular one, how would this look like? The below won't work. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">({ &lt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">[SAP Tabelle ]</SPAN><SPAN style="font-size: 8pt;">={'LFBK','LFB1'} &gt; }&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Änderungsbelegnr</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards,</SPAN></P><P><SPAN style="font-size: 8pt;">Daniela</SPAN></P></BODY></HTML> Thu, 25 Aug 2016 14:48:12 GMT https://community.qlik.com/t5/QlikView/Count-Distinct-with-condition-in-Text-Object/m-p/1173434#M462756 2016-08-25T14:48:12Z Re: Count Distinct with condition in Text Object? https://community.qlik.com/t5/QlikView/Count-Distinct-with-condition-in-Text-Object/m-p/1173435#M462757 <HTML><HEAD></HEAD><BODY><P>Thanks a lot. The round brackets after "Distinct" are not necessary.</P></BODY></HTML> Thu, 25 Aug 2016 14:50:15 GMT https://community.qlik.com/t5/QlikView/Count-Distinct-with-condition-in-Text-Object/m-p/1173435#M462757 2016-08-25T14:50:15Z