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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
prabunakil
Contributor III
Contributor III

Conditional sub total in pivot tables to show on right side

Hi,

i  am trying to only show the subtotal row when more than one expression – without losing the grant total.

In the example below only i only want to show the quarter sales target showing on the right side instead of repeat on every month. Please see picture attach and assist. 

Sample File_Qlikview.jpg

Labels (1)
3 Replies
jduenyas
Specialist
Specialist

Set the Conditional value of the calculated field to 0 and check the conditional checkbox

 

 

prabunakil
Contributor III
Contributor III
Author

Hi 

 

I am using Qlikview 9.0

maxronny
Contributor III
Contributor III

make a selection only for the "invoice sales".

if you have problems, post the qvw file