topic Two differents field date in QlikView https://community.qlik.com/t5/QlikView/Two-differents-field-date/m-p/883565#M308155 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><BR />I want to have , for example, DATE: 7/10/2015 and show me exactly what happened that day , sales of products with date of sale and customer sales records with dates. And this can be extrapolated to any registration or date type.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Sales: <STRONG>Count( {&lt;&nbsp; id_state={7} &gt;}id_sales)</STRONG><BR />If the dimension is date_c(8/7/15): 5 sales</SPAN></P><P><SPAN lang="en">If the dimension es date_gest(8/7/15): 2 sales </SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Correct: <SPAN style="font-size: 13.3333330154419px;">2 sales </SPAN></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Sec: <STRONG>sum(sec</STRONG>)</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN lang="en">If the dimension is date_c(8/7/15): 2186 sec</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN lang="en">If the dimension es date_gest(8/7/15): 995 sec</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Correct: <SPAN style="font-size: 13.3333330154419px;">2186 sec</SPAN></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">I need a DATE than show me 2 sales and 2186 sec.</SPAN></P><P><SPAN lang="en"><BR />Attaching a document to see exactly what i Need.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Thank you!!!<BR /> <BR /></SPAN></P></BODY></HTML> Wed, 15 Jul 2015 17:52:41 GMT 2015-07-15T17:52:41Z Two differents field date https://community.qlik.com/t5/QlikView/Two-differents-field-date/m-p/883565#M308155 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><BR />I want to have , for example, DATE: 7/10/2015 and show me exactly what happened that day , sales of products with date of sale and customer sales records with dates. And this can be extrapolated to any registration or date type.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Sales: <STRONG>Count( {&lt;&nbsp; id_state={7} &gt;}id_sales)</STRONG><BR />If the dimension is date_c(8/7/15): 5 sales</SPAN></P><P><SPAN lang="en">If the dimension es date_gest(8/7/15): 2 sales </SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Correct: <SPAN style="font-size: 13.3333330154419px;">2 sales </SPAN></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Sec: <STRONG>sum(sec</STRONG>)</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN lang="en">If the dimension is date_c(8/7/15): 2186 sec</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN lang="en">If the dimension es date_gest(8/7/15): 995 sec</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Correct: <SPAN style="font-size: 13.3333330154419px;">2186 sec</SPAN></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">I need a DATE than show me 2 sales and 2186 sec.</SPAN></P><P><SPAN lang="en"><BR />Attaching a document to see exactly what i Need.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Thank you!!!<BR /> <BR /></SPAN></P></BODY></HTML> Wed, 15 Jul 2015 17:52:41 GMT https://community.qlik.com/t5/QlikView/Two-differents-field-date/m-p/883565#M308155 2015-07-15T17:52:41Z Re: Two differents field date https://community.qlik.com/t5/QlikView/Two-differents-field-date/m-p/883566#M308156 <HTML><HEAD></HEAD><BODY><P>Take a look at this example:</P><P><SPAN>Qlikview Cookbook: Tutorial - Using Common Date Dimensions </SPAN><A class="jive-link-external-small" href="http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/" rel="nofollow">http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/</A></P><P></P><P>-Rob</P></BODY></HTML> Wed, 15 Jul 2015 22:48:00 GMT https://community.qlik.com/t5/QlikView/Two-differents-field-date/m-p/883566#M308156 rwunderlich 2015-07-15T22:48:00Z