topic SubTotal in QlikView https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155643#M377090 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a pivot table with Typical information Actual Year -Budget - Last Year. The pivot goes well. But Budget dont have a column in excel, just bring information to account level so for each account qlikview obviously repeat the same total.</P><P>So I would like to show only the the subtotal budget when I do clic (Drill Down) on the last level. All value they have to be null...</P><P></P><P>I put an excel example for better understanding.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 26 May 2016 21:35:43 GMT pgalvezt 2016-05-26T21:35:43Z SubTotal https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155643#M377090 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a pivot table with Typical information Actual Year -Budget - Last Year. The pivot goes well. But Budget dont have a column in excel, just bring information to account level so for each account qlikview obviously repeat the same total.</P><P>So I would like to show only the the subtotal budget when I do clic (Drill Down) on the last level. All value they have to be null...</P><P></P><P>I put an excel example for better understanding.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 26 May 2016 21:35:43 GMT https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155643#M377090 pgalvezt 2016-05-26T21:35:43Z Re: SubTotal https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155644#M377091 <HTML><HEAD></HEAD><BODY><P>Would you be able to share the sample application to try it out?</P></BODY></HTML> Thu, 26 May 2016 22:24:11 GMT https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155644#M377091 sunny_talwar 2016-05-26T22:24:11Z Re: SubTotal https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155645#M377092 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Left a qvw example...</P></BODY></HTML> Thu, 26 May 2016 22:36:35 GMT https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155645#M377092 pgalvezt 2016-05-26T22:36:35Z Re: SubTotal https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155646#M377093 <HTML><HEAD></HEAD><BODY><P>Can you try the attached</P></BODY></HTML> Thu, 26 May 2016 22:44:44 GMT https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155646#M377093 sunny_talwar 2016-05-26T22:44:44Z Re: SubTotal https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155647#M377094 <HTML><HEAD></HEAD><BODY><P>Nice Sunny Thanks!</P><P></P><P>Could You pls explain how did you get this?</P></BODY></HTML> Thu, 26 May 2016 23:01:55 GMT https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155647#M377094 pgalvezt 2016-05-26T23:01:55Z Re: SubTotal https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155648#M377095 <HTML><HEAD></HEAD><BODY><P>Dimensionality() function returns a different number based on the collapsed/expanded dimension. In your case you have three dimensions, when we have all expanded, dimensionality() gives 3</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125950_Capture.PNG" style="height: 140px; width: 620px;" /></P><P></P><P>When the DescrFormREM is collapsed, dimensionality() will give 2</P><P><IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/125963_Capture.PNG" style="height: auto;" /></P><P>and so on...</P><P></P><P>Using that I told the expression to show Plan when Dimensionality() &lt;= 2</P></BODY></HTML> Thu, 26 May 2016 23:49:40 GMT https://community.qlik.com/t5/QlikView/SubTotal/m-p/1155648#M377095 sunny_talwar 2016-05-26T23:49:40Z