topic SHOW DAYS in QlikView https://community.qlik.com/t5/QlikView/SHOW-DAYS/m-p/186226#M50406 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P><BR />Selecting a month and using this expression:</P><P>SUM({&lt;DAY={"$(=timestamp(Addmonths(only(DAY),-1)))"}NET_PRICE)</P><P></P><P>/ SUM({&lt;DAY={"$(=timestamp(addyears(Addmonths(only(DAY),-1),-1)))"},STATUS={'CONTRACT'},IS_MERCHANT={'Y'}&gt;}NET_PRICE)*</P><P></P><P>SUM({&lt;DAY={"$(=timestamp(addyears(only(DAY),-1)))"},STATUS={'CONTRACT'},IS_MERCHANT={'Y'}&gt;}NET_PRICE)</P><BR /><BR /> <BR /><BR /> <P></P><P></P><BR /><BR /> <P>How can I show the result for each day of the month selected??</P><P>regards!</P></BODY></HTML> Wed, 26 Jan 2011 15:45:15 GMT 2011-01-26T15:45:15Z SHOW DAYS https://community.qlik.com/t5/QlikView/SHOW-DAYS/m-p/186226#M50406 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P><BR />Selecting a month and using this expression:</P><P>SUM({&lt;DAY={"$(=timestamp(Addmonths(only(DAY),-1)))"}NET_PRICE)</P><P></P><P>/ SUM({&lt;DAY={"$(=timestamp(addyears(Addmonths(only(DAY),-1),-1)))"},STATUS={'CONTRACT'},IS_MERCHANT={'Y'}&gt;}NET_PRICE)*</P><P></P><P>SUM({&lt;DAY={"$(=timestamp(addyears(only(DAY),-1)))"},STATUS={'CONTRACT'},IS_MERCHANT={'Y'}&gt;}NET_PRICE)</P><BR /><BR /> <BR /><BR /> <P></P><P></P><BR /><BR /> <P>How can I show the result for each day of the month selected??</P><P>regards!</P></BODY></HTML> Wed, 26 Jan 2011 15:45:15 GMT https://community.qlik.com/t5/QlikView/SHOW-DAYS/m-p/186226#M50406 2011-01-26T15:45:15Z