Showing only Grand Total

[venkat1]

Hello friends,

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?

[Brett_Bleess]

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.

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.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Pivot_Table.htm

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:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett