Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-03-17 04:44 AM

Partial sum expression!

Hello everyone,

I'm trying to create pivot chart similar to table below. Total for Total 1 value is sum of Media 1 and Media 2 value (10 + 30), and total for Total 2 value is sum of Media 3,Media 4, Media 5 plus Total 1 (15 + 5 + 40). I don't know how to achieve total for Total 2. Any help is welcome.

1.png

Thanks in advance

475 Views
0 Likes
4 Replies
alexandros17
Partner - Champion III
Partner - Champion III
‎2014-03-17 04:46 AM

If you provide your data I can help you in detail, at the moment I can suggest to use "Above" instruction ...

Hope it helps

368 Views
0 Likes
manojkulkarni
Partner - Specialist II
Partner - Specialist II
‎2014-03-17 04:53 AM

How are you deriving Total1 & Total2 ?

368 Views
0 Likes
Not applicable
‎2014-03-17 04:58 AM
Author

Can you share a sample app with small data?

368 Views
0 Likes
MK_QSL
MVP
MVP
‎2014-03-17 05:01 AM

Can you provide sample apps or data file please?

368 Views
0 Likes