Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Don't SubTotal Text Field?

I have a pivot table with several calculations and then a text based field for comments. I need to have subtotals enabled for the calculated columns but I don't want the comments fields to show at the subtotal level. How can I make those bolded comments not be displayed?

4-13-2017 8-44-28 AM.jpg

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Don't SubTotal Text Field?

Hi,

Change the Variance Explanation formula as below.

=if(Dimensionality()=3,if(AU_NUM='100000',only({<[NOTE_TYPE] = {'MTD'},EXP_TYPE_CODE={'Capital'}>}NOTE),only({<[NOTE_TYPE] = {'MTD'},EXP_TYPE_CODE={'Operating'}>}NOTE)))

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Don't SubTotal Text Field?

Hi,

Change the Variance Explanation formula as below.

=if(Dimensionality()=3,if(AU_NUM='100000',only({<[NOTE_TYPE] = {'MTD'},EXP_TYPE_CODE={'Capital'}>}NOTE),only({<[NOTE_TYPE] = {'MTD'},EXP_TYPE_CODE={'Operating'}>}NOTE)))

View solution in original post

Highlighted
Specialist
Specialist

Re: Don't SubTotal Text Field?

Thanks!