https://community.qlik.com/t5/QlikView/Showing-only-Grand-Total/m-p/1677468#M506441 <P>Hello friends,<BR /><BR /></P><P>in my sheet i have list box(Adhoc dimensions) and a pivot table,where if i select multi values from the list only One total should come,how to over come from this?<BR /><BR /></P> Thu, 20 Feb 2020 10:29:07 GMT venkat1 2020-02-20T10:29:07Z https://community.qlik.com/t5/QlikView/Showing-only-Grand-Total/m-p/1677468#M506441 <P>Hello friends,<BR /><BR /></P><P>in my sheet i have list box(Adhoc dimensions) and a pivot table,where if i select multi values from the list only One total should come,how to over come from this?<BR /><BR /></P> Thu, 20 Feb 2020 10:29:07 GMT https://community.qlik.com/t5/QlikView/Showing-only-Grand-Total/m-p/1677468#M506441 venkat1 2020-02-20T10:29:07Z https://community.qlik.com/t5/QlikView/Showing-only-Grand-Total/m-p/1687802#M506442 <P>It will likely be advisable to attach a sample QVW file so folks can see your data model, the chart and its settings etc. in order to get some decent advice on this one.</P><P>Have a look at the Help and in particular the Expression total versus Dimension total, I think that may be for what you are looking in this case.</P><P><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Pivot_Table.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Pivot_Table.htm</A></P><P>You may need to poke around the Design Blog area potentially for some help on your Expression to get things right there, here is the base URL for that area:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog</A></P><P>Regards,<BR />Brett</P> Wed, 25 Mar 2020 18:29:28 GMT https://community.qlik.com/t5/QlikView/Showing-only-Grand-Total/m-p/1687802#M506442 Brett_Bleess 2020-03-25T18:29:28Z