Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Showing only Grand Total

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?

1 Reply
Highlighted
Digital Support
Digital Support

Re: Showing only Grand Total

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.