topic Set analysis in QlikView https://community.qlik.com/t5/QlikView/Set-analysis/m-p/681171#M246961 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>Please support in below requirement. I need to achieve this requirement in front end only.</P><P></P><P>Requirement :- I need to create pivot table with creation date (CRE_DT) as dimension and one expression</P><P>1) No ETD&nbsp; -- count(LATEST_ETD where LATEST_ETD = 99999999) But here i need to consider ORD_DT and ORD_TIME. i.e.</P><P>For each creation dates(CRE_DT) there will be set of ORD_DT and ORD_TIME, In each case i need to consider upto Max(ORD_DT and ORD_TIME &lt;= 163000).</P><P></P><P>Business Logic :- My WH team will receive orders whole day but for this report i need to consider orders received upto 4.30 PM. EG:-</P><P>IF Creation Date :- 1ST JAN&nbsp; 2014 then for this date i will have many ORDER DATES eg:- (1st SEP 2013 to 29th DEC 2013 till mid night) but for my report i need to consider 1st SEP 2013 full Day&nbsp; to 29th DEC 2013 4.30 PM.</P><P></P><P>Please find sample data and application. Please support.</P><P></P><P>Note :-&nbsp; I need to do in front end only. (set analysis).</P><P></P><P>Thanks in advance.&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 08 Oct 2014 10:20:36 GMT varunvarma 2014-10-08T10:20:36Z Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/681171#M246961 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>Please support in below requirement. I need to achieve this requirement in front end only.</P><P></P><P>Requirement :- I need to create pivot table with creation date (CRE_DT) as dimension and one expression</P><P>1) No ETD&nbsp; -- count(LATEST_ETD where LATEST_ETD = 99999999) But here i need to consider ORD_DT and ORD_TIME. i.e.</P><P>For each creation dates(CRE_DT) there will be set of ORD_DT and ORD_TIME, In each case i need to consider upto Max(ORD_DT and ORD_TIME &lt;= 163000).</P><P></P><P>Business Logic :- My WH team will receive orders whole day but for this report i need to consider orders received upto 4.30 PM. EG:-</P><P>IF Creation Date :- 1ST JAN&nbsp; 2014 then for this date i will have many ORDER DATES eg:- (1st SEP 2013 to 29th DEC 2013 till mid night) but for my report i need to consider 1st SEP 2013 full Day&nbsp; to 29th DEC 2013 4.30 PM.</P><P></P><P>Please find sample data and application. Please support.</P><P></P><P>Note :-&nbsp; I need to do in front end only. (set analysis).</P><P></P><P>Thanks in advance.&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 08 Oct 2014 10:20:36 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/681171#M246961 varunvarma 2014-10-08T10:20:36Z Re: Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/681172#M246962 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>Is there any way to do above requirement. Please suggest me.</P></BODY></HTML> Thu, 09 Oct 2014 03:01:39 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/681172#M246962 varunvarma 2014-10-09T03:01:39Z