topic Set analysis code error in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-code-error/m-p/250362#M1193365 <HTML><HEAD></HEAD><BODY><P>Hi, Bikash</P><P></P><P>Sometimes, set analysis does not handle the date format very well. </P><P>I suggest you use a auxiliary field for the DW date as an integer. </P><P>In the script, where you have something like: </P><P>Load </P><P>DW_LOAD_DATE, </P><P>... ETC</P><P></P><P>, include another line</P><P>load </P><P>DW_LOAD_DATE,</P><P>num(DW_LOAD_DATE) as nDW_DATE,</P><P>... etc</P><P></P><P>Your vConvStart and vConvEnd should get max and min of this new field</P><P>=min(nDW_DATE) and = max(nDW_DATE)</P><P></P><P>Your set analysis should also change to compare nDW_DATE instead of DW_LOAD_DATE</P><P>hope this helps, </P><P></P><P>Erich</P></BODY></HTML> Sat, 02 Jul 2011 11:51:20 GMT erichshiino 2011-07-02T11:51:20Z Set analysis code error https://community.qlik.com/t5/QlikView/Set-analysis-code-error/m-p/250361#M1193364 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have attached a picture about my problem statement.</P><P>Hope I was able to pictorially explain whats going wrong.</P><P></P><P>Please help,</P><P></P><P>Regards,</P><P>Bikash</P></BODY></HTML> Fri, 01 Jul 2011 22:54:06 GMT https://community.qlik.com/t5/QlikView/Set-analysis-code-error/m-p/250361#M1193364 2011-07-01T22:54:06Z Set analysis code error https://community.qlik.com/t5/QlikView/Set-analysis-code-error/m-p/250362#M1193365 <HTML><HEAD></HEAD><BODY><P>Hi, Bikash</P><P></P><P>Sometimes, set analysis does not handle the date format very well. </P><P>I suggest you use a auxiliary field for the DW date as an integer. </P><P>In the script, where you have something like: </P><P>Load </P><P>DW_LOAD_DATE, </P><P>... ETC</P><P></P><P>, include another line</P><P>load </P><P>DW_LOAD_DATE,</P><P>num(DW_LOAD_DATE) as nDW_DATE,</P><P>... etc</P><P></P><P>Your vConvStart and vConvEnd should get max and min of this new field</P><P>=min(nDW_DATE) and = max(nDW_DATE)</P><P></P><P>Your set analysis should also change to compare nDW_DATE instead of DW_LOAD_DATE</P><P>hope this helps, </P><P></P><P>Erich</P></BODY></HTML> Sat, 02 Jul 2011 11:51:20 GMT https://community.qlik.com/t5/QlikView/Set-analysis-code-error/m-p/250362#M1193365 erichshiino 2011-07-02T11:51:20Z