Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Need help in Pivot Design

Dear All,

In Pivot Table is there a way of Displaying the' Total' With Different Name.

For Example:

Sub-Total Displaying for the Region Dimension Should Display With

Total North

Total South

Total West

Total East

Total Displaying for the Country Dimension :

Total India.

I have attached Screenshots .

Any help will be appreciated.

          Thanks in advance.

Thanks and Regards

Nikitha Jain M.B

7 Replies
thornofcrowns
Valued Contributor II

Re: Need help in Pivot Design

Not applicable

Re: Need help in Pivot Design

Hi Nikhita,

Have you tried using the option "label for Totals" in the presentation tab?

Re: Need help in Pivot Design

Hi,

You can use Subtotals option from the properties -> Presentation -> Subtotals.

Hope this helps

Thanks & Regards

MVP
MVP

Re: Need help in Pivot Design

This is not yet possible in qv. You might want to vote for the same idea here:http://community.qlik.com/ideas/1156

sushil353
Honored Contributor II

Re: Need help in Pivot Design

i guess the solution you are looking in is not possible ..

See below thread

Dynamic Totals Label

HTH

Sushil

Re: Need help in Pivot Design

Hi,

See the attached snap

Sample.png

Hope this help

Not applicable

Re: Need help in Pivot Design

Hi,

Thanks all  For the Reply

I know the option under Presentation Tab.

But i want the Name to be Changed Dyanamically.

Even i tried using the Expression in LABELS OR TOTALS  under Presntation Tab as

='Total' &' '&Country  it works for the country i.e it shows as Total India

But the same is not working for Region and States.

Community Browser