topic Re: Pivot Table , Presentation Tab, Show Partail Sums, Label for Totals in QlikView

Pivot Table , Presentation Tab, Show Partail Sums, Label for Totals

Fri, 22 Nov 2013 16:11:31 GMT

Is it possible to calculate the label to represent the Dimension shown in the partial sum . I tried this in the Labels for Total

=[Marketing Style] but it returns - .

Thanks

Frank

Re: Pivot Table , Presentation Tab, Show Partail Sums, Label for Totals

Tue, 26 Nov 2013 15:08:16 GMT

I take it that it is not possible to do this in Qlikview

Re: Pivot Table , Presentation Tab, Show Partail Sums, Label for Totals

jerem1234 — Tue, 26 Nov 2013 15:34:15 GMT

Nope, I do not think it is possible. It seems there is no way to differentiate partial sum labels for different values for a dimension. The label is static across all dimensions.

Re: Pivot Table , Presentation Tab, Show Partail Sums, Label for Totals

jvitantonio — Tue, 26 Nov 2013 15:43:16 GMT

Yes you can do this. if you want to use the file name, just write

Marketing Style (no = sign or [ ] ).

If you want to select, let's say the maximum value in that dimension, you can do something like this:

=maxstring([Marketing Style])

I hope this helps.

BI Experience | A place to share our Business Intelligence experiences

Re: Pivot Table , Presentation Tab, Show Partail Sums, Label for Totals

Tue, 26 Nov 2013 16:19:45 GMT

Hi,

Thanks for the clarification.

Regards

Frank

>>> jerem1234 <qcwebmaster@qlik.com> 26/11/2013 15:35 >>>

QlikCommunity

( http://community.qlik.com/)

Pivot Table , Presentation Tab, Show Partail Sums, Label for Totals

reply from jerem1234

(

http://community.qlik.com/people/jerem1234?et=watches.email.thread)

in App Development - View the full discussion

(

http://community.qlik.com/message/428054?et=watches.email.thread#428054)

Nope, I do not think it is possible. It seems there is no way to

differentiate partial sum labels for different values for a dimension.

The label is static across all dimensions.

Reply to this message by replying to this email, or go to the message

on QlikCommunity

(

http://community.qlik.com/message/428054?et=watches.email.thread#428054)

Start a new discussion in App Development by email

(

mailto:discussions-community-discussion~~forums-app~~d@qliktech-public.hosted.jivesoftware.com)

or at QlikCommunity

(

http://community.qlik.com/choose-container.jspa?contentType=1&containerType=14&container=2051&et=watches.email.thread)

Following Pivot Table , Presentation Tab, Show Partail Sums, Label for

Totals

(

http://community.qlik.com/message/428054?et=watches.email.thread#428054)

in these streams: Inbox

1993-2013 QlikTech International AB Copyright & Trademarks

( http://www.qlik.com/us/info/copyright) | Privacy

( http://www.qlik.com/us/info/privacy) | Terms of Use

( http://www.qlik.com/us/info/terms-of-use) | Software EULA

( http://www.qlik.com/us/info/software-eula)

Miller Group Holdings (UK) Limited - SC453327

Miller Homes Limited Registered in Scotland - SC255429

Miller Construction (UK) Limited Registered in Scotland - SC209666

Miller Developments Limited Registered in Scotland - SC178108

2 Lochside View, Edinburgh Park, Edinburgh, EH12 9DH

Disclaimer: The Information in this e-mail is confidential and for use

by the addressee(s) only.

It may also be privileged. If you are not the intended recipient please

notify us immediately on +44 (0) 870 336 5000

and delete the message from your computer: you may not copy or forward

it, or use or disclose its contents to any other person.

We do not accept any liability or responsibility for: (1) changes made

to this email after it was sent,

or (2) viruses transmitted through this email or any attachment.

Re: Re: Pivot Table , Presentation Tab, Show Partail Sums, Label for Totals

Anonymous — Tue, 26 Nov 2013 19:10:14 GMT

Frank

All the values displayed for subtotals will be the same. You can test this by using something like

= sum( [YourFactField] )

This will sum all your Fact Values for the whole pivot table and repeatedly display that.

Maybe somebody cleverer than me could rustle up something cunning with Aggr(), but I somehow doubt it.

Best Regards, Bill