topic how to get current season code from list(season_code feild) in QlikView https://community.qlik.com/t5/QlikView/how-to-get-current-season-code-from-list-season-code-feild/m-p/1436087#M797727 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>i want to define a variable as current_sales in which i want to write case statement for getting current sales </P><P>if sold_month is between aug to dec then i should have value as 17A , 18A ,19A etc... whichever season code is latest in my season _code field.</P><P>otherwise i&nbsp; want&nbsp; sold_month&nbsp; from jan to july so for that values will be 17P ,18P and etc.....</P><P></P><P><IMG alt="paint1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187688_paint1.png" style="height: 233px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z how to get current season code from list(season_code feild) https://community.qlik.com/t5/QlikView/how-to-get-current-season-code-from-list-season-code-feild/m-p/1436087#M797727 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>i want to define a variable as current_sales in which i want to write case statement for getting current sales </P><P>if sold_month is between aug to dec then i should have value as 17A , 18A ,19A etc... whichever season code is latest in my season _code field.</P><P>otherwise i&nbsp; want&nbsp; sold_month&nbsp; from jan to july so for that values will be 17P ,18P and etc.....</P><P></P><P><IMG alt="paint1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187688_paint1.png" style="height: 233px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-get-current-season-code-from-list-season-code-feild/m-p/1436087#M797727 Anonymous 2020-11-25T16:16:04Z