topic Re: Don't SubTotal Text Field? in QlikView

Don't SubTotal Text Field?

cbaqir — Thu, 13 Apr 2017 15:45:31 GMT

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?

Re: Don't SubTotal Text Field?

krishnacbe — Thu, 13 Apr 2017 15:51:41 GMT

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)))

Re: Don't SubTotal Text Field?

cbaqir — Thu, 13 Apr 2017 15:54:11 GMT

Thanks!