Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. 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