Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

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

 

 

Highlighted
Contributor III
Contributor III

Hi 

 

I am using Qlikview 9.0

Highlighted
Contributor III
Contributor III

make a selection only for the "invoice sales".

if you have problems, post the qvw file