topic Re: Show only Total on Straight Table in QlikView

Show only Total on Straight Table

n1ef5ng1 — Thu, 25 Apr 2013 09:26:22 GMT

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.

Re: Show only Total on Straight Table

sushil353 — Thu, 25 Apr 2013 09:28:21 GMT

Please explain your requirement a bit more...

and give some example and screenshots..

HTH

Sushil

Re: Show only Total on Straight Table

n1ef5ng1 — Thu, 25 Apr 2013 09:34:07 GMT

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.

Re: Show only Total on Straight Table

er_mohit — Thu, 25 Apr 2013 09:39:16 GMT

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