Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

freeze grand total

Hi all,

Jyothish KC

i want to freeze the grand total row.

it means  ..  last row   grand total  irrespective of rows   the grand total column should show .  if scroll is there also i want to show grand total column fit to table only.

Tags (2)
8 Replies
Highlighted
Master II
Master II

Re: freeze grand total

Hi Sony,

One easy way is to show total at top

Capture.PNG

Br,

KC

Best Regards,
KC
Highlighted
Specialist III
Specialist III

Re: freeze grand total

thanks KC.    but my user wants to  see bottom only .

is there any workaround?

Highlighted
Master II
Master II

Re: freeze grand total

Try this:

I have used text box, you can customize the look and feel.

Br,

KC

Best Regards,
KC
Highlighted
Specialist III
Specialist III

Re: freeze grand total

no KC... it will not accept  user will be more specific

any other idea? 

tell me one thing -- by default object we cant achieve this right?Marcus Sommer

Highlighted
MVP & Luminary
MVP & Luminary

Re: freeze grand total

With the default-tables it's not possible. The totals are part of the scrollable area (completly by pivots and partly by straight-tables) and therefore are moving within them. Usually is the from jyothish8807 mentioned option to set the totals on top the most suitable approach to display the totals.

An alternatively could be to use in general several objects if you want to provide an aggregated and a detailed view at the same time - maybe within a container in grid-mode.

- Marcus

Highlighted
Creator
Creator

Re: freeze grand total

Hi Sony,

I don't Think its possible using Pivot Table, Instead of Pivot table you can use a straight table. and in expression using set analysis you can achieve it.

Highlighted
Specialist III
Specialist III

Re: freeze grand total

but mine is adhoc report    so i cant restrict the total column every time  ,,,user can seelct one dim and one measure  ,some times more he will. 

Highlighted
MVP & Luminary
MVP & Luminary

Re: freeze grand total

My above mentioned approach of using multiple objects within a container should in general also work by a dynamic chart whereby I rather doubt that it will really satisfy you.

But I don't really understand why the position of the totals is particular in any way especially by an adhoc report. For me it indicates that an user actively worked with the object and with the arrows-keys and/or ctrl + shift + pos1/ende an user could move easily within the object.

- Marcus