topic Re: Show only final total in pivot table in QlikView

Show only final total in pivot table

surajap123 — Thu, 22 May 2014 10:51:22 GMT

Hi All,

I have multiple dimensions in pivot table, so that i get grouped result for my rexpressions.

I only want to show final total for each expression in pivot table. I dont want to show each row level detail in the pivot table.

So, how can i hide all the rows and show only the final total amount(which we generally see in the bottom of the pivot table when we scroll to the end) of each expression column?

Re: Show only final total in pivot table

SunilChauhan — Thu, 22 May 2014 10:53:39 GMT

use variable

for example

let var=sum(total Fieldname);

and use $(var ) in expression

Re: Show only final total in pivot table

surajap123 — Thu, 22 May 2014 14:30:39 GMT

Hi Sunil,

What I understand is, i need to create a variable in qlikview script and use that variable in my pivot table in front end. Am i right?

Re: Show only final total in pivot table

Thu, 22 May 2014 14:34:00 GMT

If you go to Settings -> Variable Overview, it'll allow you to add the variable

Re: Show only final total in pivot table

SunilChauhan — Thu, 22 May 2014 15:51:57 GMT

you can create either in script or in Variable overview(Ctrl+alt+V)

if want in script

set var=sum(total Fieldname); this will work for your scnanario i thing

let var=sum(total Fieldname);

or if want in variable overview

Ctrl+alt+v

then cliclk on add bttion-> name the variable and variable expression

hope this helps