topic Re: Any day vs 7 days ago data in QlikView https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412072#M488787 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>Im using Qlikview personal edition. can i have the script paste here? </P><P></P><P>Many Thanks</P><P></P><P>Mazda</P></BODY></HTML> Mon, 09 Jul 2018 07:13:06 GMT Anonymous 2018-07-09T07:13:06Z Any day vs 7 days ago data https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412064#M488772 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hi all!</SPAN></P><P><SPAN style="color: #000000;">I have the following data:</SPAN></P><P><SPAN style="color: #000000;">Date and Value.</SPAN></P><P><SPAN style="color: #000000; font-family: Arial; background-color: #ffffff;">In table I want to get the Value for any Day, but alsoValue for the 7 days ago:</SPAN></P><P><SPAN style="color: #000000; font-family: Arial; background-color: #ffffff;"><IMG __jive_id="26488" class="jive-image" alt="Date and Value.png" src="/legacyfs/online/26488_Date and Value.png" /><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: Arial; background-color: #ffffff;">I use the expression: <STRONG>sum( {$&lt;Day=,Month =,Date = {"$(=date(Date-7))"}&gt;}Value ) </STRONG> but it doesn't work correctly.</SPAN></P><P><SPAN style="color: #000000; font-family: Arial; background-color: #ffffff;">In Qlickview like this:</SPAN></P><P><SPAN style="color: #000000; font-family: Arial; background-color: #ffffff;"><IMG __jive_id="26495" class="jive-image-thumbnail jive-image" onclick="" alt="result.png" src="https://community.qlik.com/legacyfs/online/26495_result.png" width="450" /></SPAN></P><P><SPAN style="color: #000000; font-family: Arial; background-color: #ffffff;">For any date i must have 2 Values : Value for date and Value for date-7 ago but idon't know how to solve this problem without load two values in script. Can any help?<BR /></SPAN></P><P><SPAN style="color: #000000; font-family: Arial; background-color: #ffffff;"><STRONG><BR /></STRONG></SPAN></P></BODY></HTML> Thu, 06 Dec 2012 10:23:34 GMT https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412064#M488772 2012-12-06T10:23:34Z Re: Any day vs 7 days ago data https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412065#M488773 <HTML><HEAD></HEAD><BODY><P>You can't solve this with set analysis expressions. Those are calculated once for the entire chart, not per row. If you have Values for every day and the dates are ordered like in your example you can use above(sum(Value),7) as the expression to get the sum(Value) of 7 rows above, which in this case is also 7 days ago.</P></BODY></HTML> Thu, 06 Dec 2012 11:18:50 GMT https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412065#M488773 Gysbert_Wassenaar 2012-12-06T11:18:50Z Re: Any day vs 7 days ago data https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412066#M488774 <HTML><HEAD></HEAD><BODY><P>Thank you, <SPAN style="color: #222222; font-family: arial, sans-serif; background-color: #ffffff;">Gysbert </SPAN>! I<SPAN style="color: #222222; font-family: arial, sans-serif; background-color: #ffffff;">t doen't suit mе..</SPAN><SPAN style="color: #000000; font-family: 'Times New Roman'; font-size: medium;"><IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></SPAN></P></BODY></HTML> Thu, 06 Dec 2012 12:20:55 GMT https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412066#M488774 2012-12-06T12:20:55Z Re: Any day vs 7 days ago data https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412067#M488776 <HTML><HEAD></HEAD><BODY><P>Change your dimension to a calculate dimension with expression </P><P>=GetFieldSelections( Day) &amp; '-' &amp; GetFieldSelections( Month) </P></BODY></HTML> Thu, 06 Dec 2012 12:31:36 GMT https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412067#M488776 Gysbert_Wassenaar 2012-12-06T12:31:36Z Re: Any day vs 7 days ago data https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412068#M488778 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P></P><P> PFA</P></BODY></HTML> Thu, 06 Dec 2012 13:34:35 GMT https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412068#M488778 MayilVahanan 2012-12-06T13:34:35Z Re: Any day vs 7 days ago data https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412069#M488781 <HTML><HEAD></HEAD><BODY><P>Gysbert and Mayil, Thank you! Both of solutions show value when i select day and month.</P><P>Can i see value vs previous value for all days in month? I.e. if i select month, no selection day? </P></BODY></HTML> Thu, 06 Dec 2012 13:58:04 GMT https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412069#M488781 2012-12-06T13:58:04Z Re: Any day vs 7 days ago data https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412070#M488783 <HTML><HEAD></HEAD><BODY><P>That's not possibly with set analysis expressions. The set is calculated for the entire chart/table, not per row. You'll have to deal with it in the load script. It's fairly easy. See attached example.</P></BODY></HTML> Thu, 06 Dec 2012 14:19:13 GMT https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412070#M488783 Gysbert_Wassenaar 2012-12-06T14:19:13Z Re: Any day vs 7 days ago data https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412071#M488786 <HTML><HEAD></HEAD><BODY><P>O'key, i understood, thank you,Gysbert!</P></BODY></HTML> Thu, 06 Dec 2012 14:28:57 GMT https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412071#M488786 2012-12-06T14:28:57Z Re: Any day vs 7 days ago data https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412072#M488787 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>Im using Qlikview personal edition. can i have the script paste here? </P><P></P><P>Many Thanks</P><P></P><P>Mazda</P></BODY></HTML> Mon, 09 Jul 2018 07:13:06 GMT https://community.qlik.com/t5/QlikView/Any-day-vs-7-days-ago-data/m-p/412072#M488787 Anonymous 2018-07-09T07:13:06Z