topic Re: Hide a single expressions sub-total. in QlikView

Hide a single expressions sub-total.

NickHoff — Tue, 16 May 2017 14:27:13 GMT

Hello,

I have a metric that is giving the Max(FieldName). The subtotal for a dimension provides no value and is causing confusion. However the subtotal needs to exist for the other metrics. How can I hide the sub-total shown below:

I'm able to hide the grand total using the option No Totals as shown below, but the facility sub-total shows:

Re: Hide a single expressions sub-total.

mayankraoka — Tue, 16 May 2017 14:31:43 GMT

Hi Nick,

Please see below option to play with subtotal:

if you mean to subtotals in Pivot chart, you can use RowNo() function to determine if it's a total row. In subtotals it's always 0 (except the entire-chart total).

For example, insert this syntax in the expression of the chart:

if(RowNo()=0,'Subtotal','row-data')

This is what you'll get:

Regards,

Mayank

Re: Hide a single expressions sub-total.

mayankraoka — Tue, 16 May 2017 14:34:25 GMT

Another option go to presentation if this is pivot table. Uncheck show partial sum option .

Regards,

Mayank

Re: Hide a single expressions sub-total.

NickHoff — Tue, 16 May 2017 14:37:18 GMT

Hi Mayank, the table is a straight table. I have to use a straight table for my problem because the totals don't add up correctly based on my expression. I spoke with a co-worker about the problem and it turns out I could use If(dimensionality = 1, Null(), Expression)