disable expression level

[Manni_SM]

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 .

[PrashantSangle]

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

[marcus_sommer · Accepted solution]

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

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

[Manni_SM]

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

[PrashantSangle]

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

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

Regards,

Prashant Sangle

[PrashantSangle]

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.

[Manni_SM]

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

[PrashantSangle]

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

[Manni_SM]

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

[marcus_sommer]

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