Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I take it that it is not possible to do this in Qlikview
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.
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.
JV
BI Experience | A place to share our Business Intelligence experiences
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-discussionforums-appd@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.
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