topic set analysis expression based on field value in QlikView https://community.qlik.com/t5/QlikView/set-analysis-expression-based-on-field-value/m-p/1281798#M461791 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P>i have a week day table with values which i want to calculate against WeekDay(now()) </P><P>any ideas or another way to figure it?</P><P></P><P>advanced thanks. </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>week day</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>value</STRONG></TH></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Monday</SPAN></TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Tuesday</SPAN></TD><TD style="padding: 2px;">150</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Wednesday </SPAN></TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Thursday </SPAN></TD><TD style="padding: 2px;">130</TD></TR><TR><TD style="padding: 2px;">Friday </TD><TD style="padding: 2px;">400</TD></TR><TR><TD style="padding: 2px;">Saturday </TD><TD style="padding: 2px;">330</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 05 Dec 2016 17:18:53 GMT ilanbaruch 2016-12-05T17:18:53Z set analysis expression based on field value https://community.qlik.com/t5/QlikView/set-analysis-expression-based-on-field-value/m-p/1281798#M461791 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P>i have a week day table with values which i want to calculate against WeekDay(now()) </P><P>any ideas or another way to figure it?</P><P></P><P>advanced thanks. </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>week day</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>value</STRONG></TH></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Monday</SPAN></TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Tuesday</SPAN></TD><TD style="padding: 2px;">150</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Wednesday </SPAN></TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Thursday </SPAN></TD><TD style="padding: 2px;">130</TD></TR><TR><TD style="padding: 2px;">Friday </TD><TD style="padding: 2px;">400</TD></TR><TR><TD style="padding: 2px;">Saturday </TD><TD style="padding: 2px;">330</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 05 Dec 2016 17:18:53 GMT https://community.qlik.com/t5/QlikView/set-analysis-expression-based-on-field-value/m-p/1281798#M461791 ilanbaruch 2016-12-05T17:18:53Z Re: set analysis expression based on field value https://community.qlik.com/t5/QlikView/set-analysis-expression-based-on-field-value/m-p/1281799#M461792 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can employ Date() function and here is an example by using your data:</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/145671_Capture.PNG" style="height: 291px; width: 620px;" /></P><P></P><P>Hope this helps.</P></BODY></HTML> Mon, 05 Dec 2016 17:34:04 GMT https://community.qlik.com/t5/QlikView/set-analysis-expression-based-on-field-value/m-p/1281799#M461792 sinanozdemir 2016-12-05T17:34:04Z