Show only Total on Straight Table

[n1ef5ng1]

Hi I would like to show only sub-total on the straight withuot any columns etc

possible to do it?

i have to put some variable on the dimension... so i can't remove the dimension to empty.

[sushil353]

Please explain your requirement a bit more...

and give some example and screenshots..

HTH

Sushil

[n1ef5ng1]

Hi,

I will explain in details.

I need to find weighted average of BOX

The complexity of the formula means I have to use few columns on the Straight table to derive the weighted average by sub total

However, my desire output is just showing the sub total, not the other columns. Hiding does help to remove some of the columns. However i really just want the sub total.

[er_mohit]

In Qlikview11.0 for sub total

goto properties-->dimension limit tab---> select dimension that based you want sub total--->check on show total..

hope it helps

if you don't want to show all total on upaer side then on expression tab on right side ctick on radio button for no total

hope it helps