topic Re: dicussion about functions in QlikView https://community.qlik.com/t5/QlikView/dicussion-about-functions/m-p/809375#M285666 <HTML><HEAD></HEAD><BODY><P class="MsoNormal"><STRONG style="mso-bidi-font-weight: normal;">ALL means every value in your data set, whether or not it is excluded by your current selections.</STRONG></P><P></P><P class="MsoNormal"><SPAN style="color: red;">All:-sum(all(sales)</SPAN></P><P></P><P class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;"><STRONG style="mso-bidi-font-weight: normal; mso-fareast-language: EN-IN; font-size: 12.0pt; font-family: 'Times New Roman','serif'; mso-fareast-font-family: 'Times New Roman';">So if you have five years of data, and have selected a year, and have a chart showing sum(ALL sales) by month, each month will have the same total, which will be the sum of all sales for the past five years. Note that it is now preferred to use sum({1} sales), which has the same effect.</STRONG></P><P></P><P class="MsoNormal"><SPAN style="color: red;">Total:-sum(total(sales</SPAN>)</P><P></P><P class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;"><STRONG style="mso-bidi-font-weight: normal; mso-fareast-language: EN-IN; font-size: 12.0pt; font-family: 'Times New Roman','serif'; mso-fareast-font-family: 'Times New Roman';">Total, on the other hand, does take your current selections into account. But it ignores what row you're on in a table. So back to our example, sum(TOTAL amount) would again have the same total for each month, but it would be the sum of all sales for the selected year.</STRONG></P></BODY></HTML> Fri, 27 Mar 2015 15:40:19 GMT 2015-03-27T15:40:19Z dicussion about functions https://community.qlik.com/t5/QlikView/dicussion-about-functions/m-p/809374#M285665 <HTML><HEAD></HEAD><BODY><P>what is differance between total and all in Qlikview?</P></BODY></HTML> Fri, 27 Mar 2015 15:39:35 GMT https://community.qlik.com/t5/QlikView/dicussion-about-functions/m-p/809374#M285665 2015-03-27T15:39:35Z Re: dicussion about functions https://community.qlik.com/t5/QlikView/dicussion-about-functions/m-p/809375#M285666 <HTML><HEAD></HEAD><BODY><P class="MsoNormal"><STRONG style="mso-bidi-font-weight: normal;">ALL means every value in your data set, whether or not it is excluded by your current selections.</STRONG></P><P></P><P class="MsoNormal"><SPAN style="color: red;">All:-sum(all(sales)</SPAN></P><P></P><P class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;"><STRONG style="mso-bidi-font-weight: normal; mso-fareast-language: EN-IN; font-size: 12.0pt; font-family: 'Times New Roman','serif'; mso-fareast-font-family: 'Times New Roman';">So if you have five years of data, and have selected a year, and have a chart showing sum(ALL sales) by month, each month will have the same total, which will be the sum of all sales for the past five years. Note that it is now preferred to use sum({1} sales), which has the same effect.</STRONG></P><P></P><P class="MsoNormal"><SPAN style="color: red;">Total:-sum(total(sales</SPAN>)</P><P></P><P class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;"><STRONG style="mso-bidi-font-weight: normal; mso-fareast-language: EN-IN; font-size: 12.0pt; font-family: 'Times New Roman','serif'; mso-fareast-font-family: 'Times New Roman';">Total, on the other hand, does take your current selections into account. But it ignores what row you're on in a table. So back to our example, sum(TOTAL amount) would again have the same total for each month, but it would be the sum of all sales for the selected year.</STRONG></P></BODY></HTML> Fri, 27 Mar 2015 15:40:19 GMT https://community.qlik.com/t5/QlikView/dicussion-about-functions/m-p/809375#M285666 2015-03-27T15:40:19Z Re: dicussion about functions https://community.qlik.com/t5/QlikView/dicussion-about-functions/m-p/809376#M285667 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/156907">Total ... Above</A></P></BODY></HTML> Fri, 27 Mar 2015 15:41:49 GMT https://community.qlik.com/t5/QlikView/dicussion-about-functions/m-p/809376#M285667 MK_QSL 2015-03-27T15:41:49Z