topic Problem in set analysis in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/Problem-in-set-analysis/m-p/761495#M1591 <HTML><HEAD></HEAD><BODY><P><BR />Hello</P><P></P><P><SPAN style="font-size: 12pt;">I have a problem </SPAN></P><P><SPAN style="font-size: 12pt;">In my expression, I only want to count Besteknummer (=Tender number) where the </SPAN></P><P><SPAN style="font-size: 12pt;">date in the field [Datum 7: Finale goedkeuring] is equal to the date in the field [Datum 1: Lancering Workflow]" </SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 12pt;">=Count</SPAN><SPAN style="font-size: 12pt;">(<SPAN style="color: #0000ff;">DISTINCT</SPAN>{&lt;<SPAN style="color: #800000;">[Datum 7: Finale goedkeuring]</SPAN>={<SPAN style="color: #800000;">"=[Datum 1: Lancering Workflow]"</SPAN>}&gt;}<SPAN style="color: #800000;">Besteknummer</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN></SPAN></P><P> </P><P><SPAN style="font-size: 12pt;">It doesn't work.</SPAN></P><P> </P><P><SPAN style="font-size: 12pt;">Can somebody help me ?</SPAN></P><P> </P><P><SPAN style="font-size: 12pt;">Thanks in adance</SPAN></P><P> </P><P><SPAN style="font-size: 12pt;">Marc</SPAN></P></BODY></HTML> Tue, 02 Dec 2014 15:51:08 GMT 2014-12-02T15:51:08Z Problem in set analysis https://community.qlik.com/t5/Qlik-Learning-Discussions/Problem-in-set-analysis/m-p/761495#M1591 <HTML><HEAD></HEAD><BODY><P><BR />Hello</P><P></P><P><SPAN style="font-size: 12pt;">I have a problem </SPAN></P><P><SPAN style="font-size: 12pt;">In my expression, I only want to count Besteknummer (=Tender number) where the </SPAN></P><P><SPAN style="font-size: 12pt;">date in the field [Datum 7: Finale goedkeuring] is equal to the date in the field [Datum 1: Lancering Workflow]" </SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 12pt;">=Count</SPAN><SPAN style="font-size: 12pt;">(<SPAN style="color: #0000ff;">DISTINCT</SPAN>{&lt;<SPAN style="color: #800000;">[Datum 7: Finale goedkeuring]</SPAN>={<SPAN style="color: #800000;">"=[Datum 1: Lancering Workflow]"</SPAN>}&gt;}<SPAN style="color: #800000;">Besteknummer</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN></SPAN></P><P> </P><P><SPAN style="font-size: 12pt;">It doesn't work.</SPAN></P><P> </P><P><SPAN style="font-size: 12pt;">Can somebody help me ?</SPAN></P><P> </P><P><SPAN style="font-size: 12pt;">Thanks in adance</SPAN></P><P> </P><P><SPAN style="font-size: 12pt;">Marc</SPAN></P></BODY></HTML> Tue, 02 Dec 2014 15:51:08 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Problem-in-set-analysis/m-p/761495#M1591 2014-12-02T15:51:08Z