topic Last week tfc in QlikView https://community.qlik.com/t5/QlikView/Last-week-tfc/m-p/1351450#M834751 <HTML><HEAD></HEAD><BODY><P>Hello guys,</P><P>I have a table with only one dimension: YEAR</P><P></P><P>What I need to do, is to find an expression to calculate the total traffic volume for the last available week.</P><P>eg year 2016 --&gt; week 52</P><P>year 2017 --&gt; week 20</P><P></P><P>I'm using the expression: <SPAN style="color: #0000ff; font-size: 8pt;">FirstSortedValue</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[TOTAL TRAFFIC]</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">W_order</SPAN><SPAN style="font-size: 8pt;">), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(-</SPAN><SPAN style="color: #800000; font-size: 8pt;">W_order</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">W_order</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">It works ok for the 2016, but it takes the week 52 also for the 2017.</SPAN></P><P><SPAN style="font-size: 10pt;">I think I need to put a condition like :" where total traffic is greater than 0"</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Do you have any idea?</SPAN></P><P><SPAN style="font-size: 10pt;">Many thanks in advance <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT marikabi 2020-11-25T16:16:04Z Last week tfc https://community.qlik.com/t5/QlikView/Last-week-tfc/m-p/1351450#M834751 <HTML><HEAD></HEAD><BODY><P>Hello guys,</P><P>I have a table with only one dimension: YEAR</P><P></P><P>What I need to do, is to find an expression to calculate the total traffic volume for the last available week.</P><P>eg year 2016 --&gt; week 52</P><P>year 2017 --&gt; week 20</P><P></P><P>I'm using the expression: <SPAN style="color: #0000ff; font-size: 8pt;">FirstSortedValue</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[TOTAL TRAFFIC]</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">W_order</SPAN><SPAN style="font-size: 8pt;">), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(-</SPAN><SPAN style="color: #800000; font-size: 8pt;">W_order</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">W_order</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">It works ok for the 2016, but it takes the week 52 also for the 2017.</SPAN></P><P><SPAN style="font-size: 10pt;">I think I need to put a condition like :" where total traffic is greater than 0"</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Do you have any idea?</SPAN></P><P><SPAN style="font-size: 10pt;">Many thanks in advance <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Last-week-tfc/m-p/1351450#M834751 marikabi 2020-11-25T16:16:04Z