topic Re: How do you make values from an expression appear only in subtotal rows? in QlikView

How do you make values from an expression appear only in subtotal rows?

Fri, 25 Oct 2013 16:57:11 GMT

I have two expression columns that are only useful for my subtotal and grand total rows. I need a way to suppress all the other values in these two columns.

Thank you for any suggestions!

Re: How do you make values from an expression appear only in subtotal rows?

stabben23 — Fri, 25 Oct 2013 17:20:51 GMT

Hi,

use something like that in textcoulor in your expression:

if(Dimensionality()=2, white())

//Stabben

Re: How do you make values from an expression appear only in subtotal rows?

Gysbert_Wassenaar — Fri, 25 Oct 2013 17:24:12 GMT

By using the dimensionality() function. See attached example. Note, if don't have any expressions that should show values at the detail level then you need to disable Suppress Zero-values or you will see no detail rows.

Re: How do you make values from an expression appear only in subtotal rows?

Fri, 25 Oct 2013 17:37:00 GMT

Thank you, that was exactly what I needed!