Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
use variable
for example
let var=sum(total Fieldname);
and use $(var ) in expression
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?
If you go to Settings -> Variable Overview, it'll allow you to add the variable
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
or
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