Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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