topic Re: disable expression level in App Development

disable expression level

Manni_SM — Wed, 18 Feb 2026 10:43:26 GMT

Hi All,

@rubenmarin @Vegar

i want to disable subtotal in pivot table from expression level how to do ?

i have 3 dimensions 2 expressions

Dimensions: A,B,C

measure1 : count(distinct id)

measure 2 : sum({<test={'y'}>} sales+profit)

how to avoid this subtotal in pivot table Qliksense .

Re: disable expression level

PrashantSangle — Wed, 18 Feb 2026 10:59:13 GMT

I believe there is no direction option to disable Total at expression (measure) level. You can control it at dimension level by go to property > select dimension > Show total > off.

but if you still want to achieve that then move that measure logic in back end & use it as dimension in front end.

Regards,

Prashant Sangle

Re: disable expression level

marcus_sommer — Wed, 18 Feb 2026 11:20:24 GMT

You may try to hide them by querying the dimensionality(), maybe like:

if(match(dimensionality(), 1, 2), null(), MyExpression)

Re: disable expression level

Manni_SM — Wed, 18 Feb 2026 13:27:04 GMT

Hi @marcus_sommer its working but i can see null value in place of subtotals how i can disable those?

Re: disable expression level

PrashantSangle — Wed, 18 Feb 2026 13:38:39 GMT

ohh.. Yes.. I forgot we can achieve it with Dimensionality().

if(Dimensionality()=1,' ', <your_expression>)

Regards,

Prashant Sangle

Re: disable expression level

PrashantSangle — Wed, 18 Feb 2026 13:40:51 GMT

1st try with just adding Dimensionality() in measure, so that you will get to know that at which level you have to hide value & at which level you have show.

Re: disable expression level

Manni_SM — Wed, 18 Feb 2026 13:48:39 GMT

i tried it looks ok but i can see null values in subtotal values how to disable those ?

Re: disable expression level

PrashantSangle — Wed, 18 Feb 2026 13:54:53 GMT

can you share screen shot of what you are trying?

Share screen shot with below

add your 3 dimension

measure 1: <your_first_expression>

measure 2: <your_second_expression>

measure 3: Dimensionality()

highlight which row you want replace with blank or null

Regards,

Prashant Sangle

Re: disable expression level

Manni_SM — Wed, 18 Feb 2026 14:51:12 GMT

Hi @PrashantSangle

measure 1: if(match(dimensionality(), 1, 2), null(), Count(distinct id)

measure2; if(match(dimensionality(), 1, 2), null(), SUM({<test={'Y'}>} sales + profit))

i have only two measures ( what to add in 3rd measure which you mentioned ?)

Re: disable expression level

marcus_sommer — Wed, 18 Feb 2026 14:59:42 GMT

Within the object-properties should be options to hide NULL and/or ZERO.

Re: disable expression level

Nagaraju_KCS — Thu, 19 Feb 2026 04:20:42 GMT

try this,
Since I have 3 dimensions Year, Month and EmpID, so actual data rows have a dimensionality of 3.

Re: disable expression level

Manni_SM — Thu, 19 Feb 2026 08:52:22 GMT

Hi @Nagaraju_KCS still its showing - symbol 😞

Re: disable expression level

Qrishna — Sun, 22 Feb 2026 16:43:51 GMT

Post some sample data and needed output