topic Set Expression Clarification in QlikView https://community.qlik.com/t5/QlikView/Set-Expression-Clarification/m-p/183368#M48660 <HTML><HEAD></HEAD><BODY><P style="line-height: normal; margin: 0in 0in 0pt;">How's everyone doing?</P><P style="line-height: normal; margin: 0in 0in 0pt;">Can someone help me clarify the difference between the following set expression? The goal is to return last 7 days [DaySeqNum] between max([DaySeqNum]-7 and max(DaySeqNum)</P><P style="line-height: normal; margin: 0in 0in 0pt;"></P><P style="line-height: normal; margin: 0in 0in 0pt;">[DaySeqNum]= {"&gt;$(=max([DaySeqNum])-7)&lt;=$(=max([DaySeqNum]))" }</P><P style="line-height: normal; margin: 0in 0in 0pt;">Correct Result (20110125 to 20110131 assuming max([DaySeqNum])=20110131)</P><P style="line-height: normal; margin: 0in 0in 0pt;">[DaySeqNum]= {"&gt;=$(=max([DaySeqNum])-7)&lt;=$(=max([DaySeqNum]))" }</P><P style="line-height: normal; margin: 0in 0in 0pt;">Incorrect Result (20110124 to 20110131 assuming max([DaySeqNum])=20110131)</P><P style="line-height: normal; margin: 0in 0in 0pt;"></P><P style="line-height: normal; margin: 0in 0in 0pt;">The only different is &gt;= versus &gt; right after the first quote. Why wouldn't &gt;= work? Shouldn't it return [DaySeqNum]-7?</P><P style="line-height: normal; margin: 0in 0in 0pt;">If there are qvw examples of set expressions filtering on date ranges, please forward them if possible.</P><P style="line-height: normal; margin: 0in 0in 0pt;"></P><P style="line-height: normal; margin: 0in 0in 0pt;">Your help is much appreciated!</P><P></P></BODY></HTML> Sun, 27 Mar 2011 04:54:49 GMT 2011-03-27T04:54:49Z Set Expression Clarification https://community.qlik.com/t5/QlikView/Set-Expression-Clarification/m-p/183368#M48660 <HTML><HEAD></HEAD><BODY><P style="line-height: normal; margin: 0in 0in 0pt;">How's everyone doing?</P><P style="line-height: normal; margin: 0in 0in 0pt;">Can someone help me clarify the difference between the following set expression? The goal is to return last 7 days [DaySeqNum] between max([DaySeqNum]-7 and max(DaySeqNum)</P><P style="line-height: normal; margin: 0in 0in 0pt;"></P><P style="line-height: normal; margin: 0in 0in 0pt;">[DaySeqNum]= {"&gt;$(=max([DaySeqNum])-7)&lt;=$(=max([DaySeqNum]))" }</P><P style="line-height: normal; margin: 0in 0in 0pt;">Correct Result (20110125 to 20110131 assuming max([DaySeqNum])=20110131)</P><P style="line-height: normal; margin: 0in 0in 0pt;">[DaySeqNum]= {"&gt;=$(=max([DaySeqNum])-7)&lt;=$(=max([DaySeqNum]))" }</P><P style="line-height: normal; margin: 0in 0in 0pt;">Incorrect Result (20110124 to 20110131 assuming max([DaySeqNum])=20110131)</P><P style="line-height: normal; margin: 0in 0in 0pt;"></P><P style="line-height: normal; margin: 0in 0in 0pt;">The only different is &gt;= versus &gt; right after the first quote. Why wouldn't &gt;= work? Shouldn't it return [DaySeqNum]-7?</P><P style="line-height: normal; margin: 0in 0in 0pt;">If there are qvw examples of set expressions filtering on date ranges, please forward them if possible.</P><P style="line-height: normal; margin: 0in 0in 0pt;"></P><P style="line-height: normal; margin: 0in 0in 0pt;">Your help is much appreciated!</P><P></P></BODY></HTML> Sun, 27 Mar 2011 04:54:49 GMT https://community.qlik.com/t5/QlikView/Set-Expression-Clarification/m-p/183368#M48660 2011-03-27T04:54:49Z Set Expression Clarification https://community.qlik.com/t5/QlikView/Set-Expression-Clarification/m-p/183369#M48661 <HTML><HEAD></HEAD><BODY><P>Please ignore. Forgive my posting. Cheers.</P></BODY></HTML> Sun, 27 Mar 2011 05:06:34 GMT https://community.qlik.com/t5/QlikView/Set-Expression-Clarification/m-p/183369#M48661 2011-03-27T05:06:34Z Set Expression Clarification https://community.qlik.com/t5/QlikView/Set-Expression-Clarification/m-p/183370#M48662 <HTML><HEAD></HEAD><BODY><P>Issue clarified =D</P></BODY></HTML> Sun, 27 Mar 2011 05:07:10 GMT https://community.qlik.com/t5/QlikView/Set-Expression-Clarification/m-p/183370#M48662 2011-03-27T05:07:10Z