topic Re: Count Distinct values for (2) fields for all records upto selected date in QlikView https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394479#M147108 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P>Any ideas for my problem...... I attached a sample app.</P></BODY></HTML> Wed, 20 Feb 2013 15:08:33 GMT 2013-02-20T15:08:33Z Count Distinct values for (2) fields for all records upto selected date https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394474#M147103 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using the following expression, but it only counts for the current date selected and not for all records UPTO that date. Please help</P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>Sum</P><P></P><P></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Distinct</SPAN><SPAN style="font-size: 8pt;"> {$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;"> ={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(=Max(Date))"</SPAN><SPAN style="font-size: 8pt;">}&gt;}abc</SPAN><SPAN style="font-size: 8pt;">),def</SPAN><SPAN style="font-size: 8pt;">,abc</SPAN></P><P><SPAN style="font-size: 8pt;">)) </SPAN></P></BODY></HTML> Fri, 01 Feb 2013 16:29:11 GMT https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394474#M147103 2013-02-01T16:29:11Z Re: Count Distinct values for (2) fields for all records upto selected date https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394475#M147104 <HTML><HEAD></HEAD><BODY><P>Have you tried with 1 instead of $?</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Sum </P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="font-size: 8pt; color: #0000ff;">Aggr</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="font-size: 8pt; color: #0000ff;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="font-size: 8pt; color: #0000ff;">Distinct</SPAN><SPAN style="font-size: 8pt;"> {<STRONG>1</STRONG>&lt;</SPAN><SPAN style="font-size: 8pt; color: #800000;">Date</SPAN><SPAN style="font-size: 8pt;"> ={</SPAN><SPAN style="font-size: 8pt; color: #800000;">"&lt;=$(=Max(Date))"</SPAN><SPAN style="font-size: 8pt;">}&gt;}abc</SPAN><SPAN style="font-size: 8pt;">),def</SPAN><SPAN style="font-size: 8pt;">,abc</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="font-size: 8pt;">))</SPAN></P></BODY></HTML> Fri, 01 Feb 2013 18:42:59 GMT https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394475#M147104 2013-02-01T18:42:59Z Re: Count Distinct values for (2) fields for all records upto selected date https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394476#M147105 <HTML><HEAD></HEAD><BODY><P>Sorry, no change... working the same way.</P></BODY></HTML> Fri, 01 Feb 2013 19:06:23 GMT https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394476#M147105 2013-02-01T19:06:23Z Re: Count Distinct values for (2) fields for all records upto selected date https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394477#M147106 <HTML><HEAD></HEAD><BODY><P>Can you share a sample app?</P></BODY></HTML> Fri, 01 Feb 2013 19:07:32 GMT https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394477#M147106 2013-02-01T19:07:32Z Re: Count Distinct values for (2) fields for all records upto selected date https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394478#M147107 <HTML><HEAD></HEAD><BODY><P>Attaching a sample app:</P><P></P><P>Now, </P><P>In the attached spreadsheet the total count for </P><P>Scenario = 1 and Timing = 1 should be 1 for Jan but it should be 2 for Feb since it should count all the Distinct values from earliest start date to current date .</P><P>Similar for Scenario 1 and Timing 2.</P></BODY></HTML> Tue, 12 Feb 2013 18:41:57 GMT https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394478#M147107 2013-02-12T18:41:57Z Re: Count Distinct values for (2) fields for all records upto selected date https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394479#M147108 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P>Any ideas for my problem...... I attached a sample app.</P></BODY></HTML> Wed, 20 Feb 2013 15:08:33 GMT https://community.qlik.com/t5/QlikView/Count-Distinct-values-for-2-fields-for-all-records-upto-selected/m-p/394479#M147108 2013-02-20T15:08:33Z